Community
Q&A
Jira
Questions
Is there any way to get a report, or gadget, or SQL queries aggregating Story points per assignee ?

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

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.

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Bunty,

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

Story Point per assignee Navigator.jpg

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

Sum of StoryPoints per Assignee.jpg

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

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

2 answers

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events