gadget for total Story Points for a Project for different PIs

vivekjain1

Hi,

I am trying to find total story points for a project at PI level. I would like to understand how many Story points are Committed Vs Delivered in a project across different PI(s) so as to understand the delivery trend of my project.

Please share your experience

Earl McCutcheon

Hello @vivekjain1 ,

Thanks for reaching out, and In Jira natively there are the Burnup and Burndown reports that will give you a breakdown of story point per sprint, as well as Next-gen versions of Burnup and Burndown reports, and a Velocity report and Next-Gen Velocity Report that gives you a breakdown across several sprints, but there is not a total project story point tracker, and for this you would want to look into an external tool to build out the report.

I would recomend setting this up in either a Google Sheet OR Excel document using one of our free connector tools either the Jira Cloud for Google Sheets (Official) add-on or the Jira Cloud for Excel (official) add-on that will allow you to export the live data from Jira to a spreadsheet where you can manipulate the data and generate reports as needed using the external tools (gSheets or Excel) features.  This will allow you to quickly refresh the data in the report as needed.

To get the summation include the Story point field and any other needed criteria in the jira filter and then do a "=sum()" formula on the story point columns for the total point value and "=sumif()" formula using a criteria for the issues that fall into alternate criteria like open or closed statuses that you wanted to compare.  

There is also some additional discussion of of using a data export for excel, as well as using a bookmarklet javascript query to do in-page summations based on backlog values in the following Thread that might also help you out:

• https://community.atlassian.com/t5/Jira-Software-questions/total-backlog-story-points/qaq-p/256332

Regards,
Earl