generate monthly and quarterly report for users in JIRA Dashboard

[subash_duraipandi]

Dear All,

I wanted to generate monthly and quarterly report for users in JIRA Dashboard .

Can you please suggest me?

thanks,

Subash

[Danut M _StonikByte_]

Hi @subash_duraipandi,

What do you want to cover in these reports, more exacyty?

Our Great Gadgets app offers many dashboard gadgets that allows creating advanced reports in Jira.

Have a look over the articles on our blog to see which one fits your needs. If you have questions or need any assistance, please don't hesitate to contact us at support@stonikbyte.com.

Thank you,

Danut Manda

[subash_duraipandi]

Thanks Danut for the response. 

I need user specific dashboard which is in built with JIRA. 

Like ..How many stories point, hours , Stories and Bugs are done by Specific user.

I am interested to use only available at JIRA or free of cost plugin if any. 

[subash_duraipandi]

@Danut M _StonikByte_ Our Org has taken the purchase StoneByte. Can you please help us provide the below solution :

How many stories point, hours , Stories and Bugs are done by Specific user on Monthly/Qtr or dates between.

thanks,

Subash

[Sanjog Sigdel]

Hey @subash_duraipandi,

Please go through this answer. I have shared the details on how to add total story points, copleted and remaining in an EPIC using Jira Automation, Smart Valus and Lookup Issues.

https://community.atlassian.com/t5/Jira-questions/Sum-up-of-story-points-of-tasks-to-epic-which-are-not-closed-yet/qaq-p/2456569

This will be useful for you to implement in your scenario.

[subash_duraipandi]

thanks @Sanjog Sigdel . I will check it.

[Sanjog Sigdel]

Hello @subash_duraipandi 

The default Jira dashboard donot have such gadgets to display How many stories point, hours , Stories and Bugs are done by Specific user. 

JIRA Automation, Lookup Issues and Smart Values

However there is a workaround.

1. Create Custom fields for your specific requirements.
2. For example create Total Story Points, Total Stories, Total Bugs, etc.
3. Now using Jira Automations, LookUp issues and Smart Values, you can do this:
   • Fetch the issues using JQL. List stories assigned to a user using LookUp issues. You will need to add JQL in that lookup issue
   • Lookup issue gives stories or bug and even hours and story points.
   • Now using smart value sum the filed you want for a particular user. 
   • Using Smart values you can pick any jira fields and custom fields you want to.
   • Sum the story points using Smart values and update the result to your Custom Field

This is the way to achieve your need. But remember, you will need to create automation for each user. So it may not be optimized and efficient way.

Atlassian Jira for Google Sheet

Another approach is to use Jira for Google Sheet. Using Atlassian Jira for Google Sheet, you can use jira function in your google sheet. Use the jira function JIRA("You JQL 'Goes here'. Keep your JQL inside here to get your result.")

Simply dump a bulk of Jira QUERy resultand then your your Excel/Google Sheets magic to operate on respective fields. Create table and charts filtering it per users, hours logged, etc.

JIRA REST API

Lasyly you can achieve more from REST API but it is too technical and needs some programming skills to achieve the outcome.

[subash_duraipandi]

Thanks Sanjog for your response. I am very new to the JIRA. can you please share the sample one if you have it? Thanks in advance