Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to calculate committed story points using jira data

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

1 answer

0 votes

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.

Suggest an answer

Log in or Sign up to answer
Site Admin

Atlassian Community Events