Summing Story Point Estimates for Statistics and Tracking

[Sara Bahrieh]

In Jira , I use Story Point Estimate for some other purpose. I’d like to see the sum of story point estimates for a group of issues without actually changing or touching the individual "Story Point" fields.

• Which report or diagram can show me the total story points estimate across selected issues?

• Is there a way I can use that data for statistics or tracking progress?

[Danut M _StonikByte_]

Hi @Sara Bahrieh,

Welcome to the Atlassian Community. 

Unfortunately, Jira doesn't provide reports or gadgets to track the sum of story points for a group of issues. You could try the method suggested by Bill, but that might not be so handy... Most likely you will need a plugin (app) from Atlassian Marketplace. 

If you want to use a plugin, our Great Gadgets app lets you sum-up the Story Points Estimate field for a filter/JQL that returns your issues and can display the result in many ways on your Jira dashboards.

Here are some examples:

Sum of Story Point Estimate field as a number - by using the Issue Filter Formula gadget

Sum of Story Point Estimate as Pivot Table split by various fields (such as Assignee and Issue Type in this example) - by using the Pivot Table & Pivot Chart gadget

Sum of Story Point Estimate along the time as CFD Chart split by status, status category or other criteria, by using the Cumulative Flow Diagram Chart gadget

Sum of Story Point Estimate along the time as Burndown or Burnup Chart - by using the Release Burndown Burnup Chart gadget

Danut 

[Marlene Kegel - codefortynine]

Welcome to the community, @Sara Bahrieh,

I am Marlene, product manager of Quick Filters for Jira Dashboards.

Another option to sum up story points (or any other Jira number field) is our app for Jira cloud. We provide a list of gadgets which enables you to aggregate Jira number fields.

• Quick Issue Statistics
• Quick Two Dimensional Filter Statistics
• Quick Pie Chart / Quick Workload Pie Chart
• Quick Bar Chart
• Quick Created vs. Resolved Chart

You can check out Quick Filters for Jira Dashboards without installation on our demo dashboards. 

[Lukas Maczejka - JXL]

Hi Sarah,

Welcome to the community!

If you’re open to a Jira premium license, Plans can likely solve your problem. It can show hierarchies and aggregated values across hierarchy for various data sources.

Just for future reference, if you’re open to solutions from the Atlassian Marketplace, your use case would also be easy to solve using the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your Jira data that allows viewing, inline-editing, copy-pasting, sorting, and filtering by all your work items' fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. It also comes with a long list of further features, including support for work item grouping based any work item field(s) and configurable sum-ups.

With these, you can build a view like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other work item fields, configure different sum-up styles (like e.g. average or median), etc. etc. This all just works - there’s no automation or scripting whatsoever required.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to conditional formatting, or inline bulk editing via copy/paste.

Any questions just let me know,
Best,

Lukas

[Bill Sheboy]

Hi @Sara Bahrieh -- Welcome to the Atlassian Community!

Short answer: There is a way to show the sum for your group of work items, but that cannot be used as an on-going report / tracking method.  For more advanced reporting options, please talk to your Jira Site Admin to learn if you have any Dashboard app gadgets which will help.

Based on using the Story Point Estimate field, I expect you are using at Team-managed Project type.  With the built-in features...

You can get that sum just-in-time using the All Work view:

• from your project, select the All Work tab
• modify the filter to show your desired work items
• on the right side of the field list, select the + sign to Configure Columns
• add the Story Point Estimate to your view
• on the right side of the page, select the ... More actions
• select View Work Items as a Chart
• select the Story Point Estimate field, and the min, max, and sum will display

Unfortunately, you would need to perform those steps when needed.

Your Jira Site Admin will know if you have any addons / apps which may help with easier reporting for this sum.

Kind regards,
Bill