Need to show consolidated efforts for each Sprint vs Assignee

[Baharul Islam Mazumder]

Hi,

I have requirements,  where Need to get report or dashboard from Jira to show Original Estimate or Time consumed in each sprint vs Assignee.

Like as below

Sprint	User-1	User-2
Sprint-1	10 days	12 days
Sprint-2	13 days	8 days

Any idea how can achieve this in Jira dashboard or using filter ?

[Ivan Garcia _Appfire_]

Hi Baharul,

Sadly, native Jira dashboards are very limited in this regard. I believe it isn't possible.

However, in case you're up to trying an addon, we develop Dashboard Hub for Jira - Reports & Charts where you could easily configure it.

This is how configuring it looks like:

I'm displaying it with story point estimates, but you could easily use Original estimate or Time Spent. Then, you would see it like this on a dashboard:

You can see a live dashboard example here. Feel free to try Dashboard Hub for Jira - Reports & Charts for free for 30 days!

Hope it helps,

Iván García, Product Marketing Manager

[Baharul Islam Mazumder]

Hi Ivan ,

Thank you for your comments. Before exploring to buy additional plugin we are trying to look if something can be done using filter itself. Trying to see if can sumup all efforts per Assignee pr Sprint basis that should satisfy our requirements.

[Karolina Wons_SaaSJet]

Hello @Baharul Islam Mazumder 

I'm not sure if there are any built-in filters, but to get the original estimate in each sprint by assignee, you can try Time in Status for Jira Cloud with its pivot table function. 

All you need is to set pivots according to your needs in a few clicks.

This add-on is developed by my team and is free for teams up to 10 users. Please, let me know if you have any questions.

Hope you find it helpful.

[Mehmet A _Bloompeak_]

Hi @Baharul Islam Mazumder

As an alternative, you can try Reports - Charts and Graphs for Jira app developed by our team to create various reports, charts and graphs for your Jira projects.

• You can create custom, flexible and colorful bar charts and table views for any data you want/need. As data source, you can choose Projects or Saved Filters or Advanced (JQL).
• You can set X axis to be any parameter like Created(month), Assignee, Sprint, Fix Versions etc.
• You can set Y axis to be any parameter like number of issues, sum of remaining estimates, average of story points etc.
• You can group your data on any field(Sprint, Status, Assignee, Component, Project etc.) you want.
• You can choose various date ranges like All Time, Last Year, Last 3 Months, Last 6 Months etc.
• You can modify existing segments or add new segments.
• You can order the results by drag and drop.

Below you can see sample reports that shows sum of original estimate by sprint and assignee.

Below you can see an article about creating custom reports, charts and graphs in Jira with our app.

How to Create Custom and Flexible Reports, Charts and Graphs in Jira

Here is our live demo dashboard where you can see and modify sample reports and play with them.

Hope it helps.

[Marlene Kegel - codefortynine]

Hi @Baharul Islam Mazumder,

I am Marlene from codefortynine.

Another option might be our Jira cloud app Quick Filters for Jira Dashboards.

This is how the configuration of the "Quick Two Dimensional Filter Statistics"  gadget could look like.

It's also possible to sum up any other number field and make statistics for other issue fields.

You can test our app without installation on our demo dashboards. One of the main features of our Quick Filters for Jira Dashboards is, that you can filter issues on your gadgets dynamically with the Quick Controller gadget.