Can I create a report with total story points per project stage?

[Roberto T]

For example, I need to know the story points totals for the cards in the To DO, Doing, blocked and Done step.

Is this possible?

[Bill Sheboy · Accepted solution]

Hi @Roberto T  -- Welcome to the Atlassian Community!

There is no a built-in way to do this with out-of-the-box JIRA.  There are marketplace add-ons to do this with query scripting or charting gadgets.

For a free solution you could:

• Create a JQL filter for your in-progress items, such as the following which would return the issues in progress or finished within the last 14 days.  Change myProject to your project name.

project = myProject
 AND status != Backlog
 AND (resolved IS EMPTY OR resolved >= -14d)
 ORDER BY status

• Add the story points field to the displayed columns
• Export the results
• Open them in a spreadsheet to sum the results by status

Best regards,
Bill

[Roberto T]

Thanks Bill
I'll try that way.

Best regards

[Bill Sheboy]

If this works for you, please consider marking this question as answered.  That will help others in the community find solutions faster.  Thanks!

[Paige Kovar]

Why has this not been added to the Filters feature as an option to appear at the bottom of the list?  Doesn't sound difficult at all - and making us go out to a 3rd party to have this ability, or exporting and using Excel, seems like a very immature-product solution.  This has been a frequent ask now for going on 5 years.

[Jigesh Patel]

Correct ! This is also has been a blocker for me to try more PMs and Business Analysts to use JIRA. Often many managers are interested in knowing how much work is left, when I answer them about "add ons" and export many of them are straight away disengaged.

[Bill Sheboy]

Hi @Jigesh Patel -- Welcome to the Atlassian Community!

Are your teams using versions or epics to manage your work?  If so, you could try the relevant burn charts to help see the remaining work.  The use case noted for this thread was generic about summing the information, and so if you have other criteria (other than version and epic containers) you could also try the dashboard gadgets.

Kind regards,
Bill