Query needed to sum all the story points for the particular PI

[Harihara Prasath V]

I am able to retrieve all the stories and story points for a particular PI.  So far, I exported the data and manually summed up the story points in excel.

Is there any way that we can do it through jira query?

[Kalyan Sattaluri · Accepted solution]

Hello @Harihara Prasath V 

Since you have script runner installed,

If you have a query which gives you all stories for a PI, lets say that is:

issueFunction in issuesInEpics("PROJECT = XXX and INCREMENT = XX") ,

then to get total story points, you will use:

 issueFunction in issuesInEpics("PROJECT = XXX and INCREMENT = XX")  AND issueFunction in aggregateExpression("Total Estimate for all Issues", "storypoints.sum()")

That is, append the bolded part to your query and it will give you total.

[Matt Parks]

@Kalyan Sattaluri  I never noticed this feature! Are you aware if there's any way to store that data so it could be displayed on a gadget in a dashboard?

[Harihara Prasath V]

Hi @Kalyan Sattaluri ,

Thanks for sharing this information.  It is working fine but I do not know where to find the script runner?

Regards,

Harihara Prasath.

[Hannes Obweger - JXL for Jira]

Hi @Harihara Prasath V

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

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

This is just one of a virtually endless number of possible views and reports; you could also do sum-ups across configurable hierarchies or groupings, configure different sum-up styles, etc. etc.

Any questions just let me know,

Best,

Hannes 

[Harihara Prasath V]

Thanks @Hannes Obweger - JXL for Jira 

[Danut M _StonikByte_]

Hi @Harihara Prasath V,

This article could be of great help for you:

https://community.atlassian.com/t5/App-Central/How-to-track-scaled-agile-SAFe-projects-in-Jira-with-Great/ba-p/1929694 

You could easily to this, without being necessary to export data in Excel, by using the Issue Filter Formula gadget or the Advanced Issue Filter Formula gadget offered by our Great Gadgets app. 

Hope this helps. If you need any assistance with these gadgets, feel free to contact support@stonikbyte.com.

Danut

[Harihara Prasath V]

Thank you @Danut M _StonikByte_