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

Harihara Prasath V March 7, 2024

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?

3 answers

1 accepted

1 vote
Answer accepted
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2024

@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 March 7, 2024

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.

1 vote
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 8, 2024

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:

sum-ups.gif

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 March 8, 2024
0 votes
Danut M _StonikByte_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 9, 2024

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

image.png

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

Danut

 

Harihara Prasath V March 11, 2024

Thank you @Danut M _StonikByte_ 

Suggest an answer

Log in or Sign up to answer