How to calculate committed story points using jira data

[Sandra Ganguly]

I need help understanding which fields/data elements are used to calculated the committed story points in jira.  What I want to do is extract the issues with the required data elements and then do a pivot table in excel which shows a more details velocity report so need to understand how I can do that with the data to show the committed story points to compare to the Done storypoints.  Thank you

[elita_kalane]

Hi all!

I accidentally found this topic by searching on something else. If this is still relevant, you can always try eazyBI app or check out some of the Demo reports related to Sprints here - https://eazybi.com/accounts/1000/dashboards/5956-sprints-overview

With eazyBI, you can import Sprint Scope measures, including Sprint Story points committed/added/changed/removed, etc. These calculations are imported automatically without users needing to create any custom calculations!

Best wishes, 

Elita from support@eazybi.com

[Trudy Claspill]

Hello @Sandra Ganguly 

Committed Story Points is a value that Jira calculates when a sprint is started by looking at the Story Points field of the standard issues in your sprint, but it is not stored in a field that you can export. Essentially you would need to export the issues in your sprint, including the Story Points values, right at the beginning of your sprint. Changes to story points during the sprint, by changing Story Point values or addition/deletion of stories after the sprint starts, does not change the Committed Story Points that were calculated at the moment the sprint started.

Done Story Points is likewise calculated by Jira when the sprint is Completed, and is also not affected by changing story point values on Done issue that were in that sprint or removing/adding issues to the sprint after the sprint has completed. So, again, you would have to export the data for the issues in the sprint at the time it is completed to get the Story Point values at the moment the sprint was completed.

[Dan Dominguez]

hi—

this seems like a function that is pretty critical to any sort of enterprise level reporting—are there plans to surface this field for export?

[Trudy Claspill]

I'm just another user of the products, not a member of the Atlassian team. I'm not aware of plans around adding an enhancement like this. You could ask your Jira Administrator to contact Atlassian Support directly to find out if there is an open change request for this.

There is at least one third party app (for Jira Cloud) available that can provide the information. I have not used it, but found it while searching the Atlassian Marketplace.

https://marketplace.atlassian.com/apps/1229698/sprint-reviewer?hosting=cloud&tab=overview

You could also pull the information using Automation Rules that are triggered at the Start and Completion of each sprint, and save the information elsewhere using Send Email or another output option.

https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/