Is there any way to get a report, or gadget, or SQL queries aggregating Story points per assignee ?

[Bunty]

Hello All,

There are 2-dimensional table gadget on the dashboard, but it only proposes to count the issues
I would like to have the same doing the SUM of story points.

Same for Report "Report: Single Level Group By Report"
It allows to aggregate per assignee, but it only counts the issues.
I would like to have the same doing the SUM of story points.

Is there a way or another to have for a given sprint the sum of story points par assignee.
(other than doing a filter + export + tune excel report with a pivot table, which is not very direct)

Would SQL+JQL add-on could help for that?

Thanks in Advance,

Manikanta.

[Earl McCutcheon · Accepted solution]

Hello,

Check out this previous Post about this:

• https://community.atlassian.com/t5/Answers-Developer-Questions/Sum-of-estimates-for-assignee-sprint-in-general/qaq-p/477917

It recommends the sumUp for Jira  add-on to accomplish this.

Regards,
Earl

[Bunty]

Hi @Earl McCutcheon,

Thanks for your reply!

No, need of Add-on. I've achieved this through the below procedure.

If you look at the sprints, you see the people that are assigned work in that sprint start and end date. To the right of the people you see 3 dots, click on the 3 dots will open a summary showing every assignee and the number of issue and associated story points assigned to them.

Thanks Again,

Manikanta.

[Samiran Misra]

Hi Bunty,

Please can you share a screen shot. I did not quite get your explanation. I am also struggling witht he above issue.

[Vani Prasanna]

Click on above 3 dots then it will display as shown below