Report showing a list of users by story points for a given (active) sprint

[John Funk]

Looking for an out of the box JQL query (not ScriptRunner) or free app that would show each assignee for a work item and the total Story Points for all of their work items on a given Sprint - at least the Open or Active Sprint at the beginning. 

[Marc -Devoteam- · Accepted solution]

HI @John Funk 

This is visible on the backlog, on a sprint select the 3-dots next to the assignees in the sprint and this should provide you with an overview of the total points per assignee.

By JQL this is not achievable, as JQL doesn't sum up.

[John Funk]

Can you show me a screenshot of that? Because I don't see totals when clicking the 3 dots, just menu options. 

[Trudy Claspill]

[John Funk]

Ah, thank you - I was clicking the wrong place. 

[Bill Sheboy]

Hi @John Funk 

What problem are you trying to solve?  That is, "why do this?"  Knowing that may help the community offer better suggestions.  Thanks!

Until we know that...

Pre-assigning work items for teams using Scrum practices may lead to unintended consequences, and perhaps reduce the effectiveness of even using sprints / iterations, team-oriented delivery, etc.  Thus, knowing the "why" may help focus suggestions.

When you still want to do this with no addons *and* the team members are known, one could use an automation rule to:

• use Lookup Work Items to gather the assigned sprint items with JQL
• use a Lookup Table, with each team member as a key and their assignments / counts / etc. as the value based on filtering / summing in the {{lookupIssues}} result
• create a report using a long-format iterator over the table, and use list filtering to remove anyone with no assigned work items 

Kind regards,
Bill

[John Funk]

It's really related to capacity planning more less. Seeing show has what % of committed story points in a Sprint. 

[Trudy Claspill]

Hello @John Funk 

What do you need to do with the output? Does it need to be presented in the Jira UI, or might it be acceptable to email the results (i.e. gathered in an Automation Rule and emailed to recipients)?

For what level of subscription is this needed? Is Atlassian Analytics available?

When you say each assignee on a work item, do you mean each distinct current assignee for the work items, or are you looking for every assignee (as the assignee has changed) on the work items?

Do you need the report to dynamically determine the Open/Active sprint or will you provide that sprint identifier? If it needs to be determined dynamically, will you be providing the Board identifier?

What if there is more than one Open/Active Sprint?

Lots of questions but no answers yet. ;-)

[John Funk]

It's really related to capacity planning more less. Seeing show has what % of committed story points in a Sprint. 

Yes, each distinct Assignee. 

I will probably provide the Sprint identifier, don't need dynamic. 

It would be per Sprint.