Does JIRA save Commitment and Completed values for the sprint into DB?

[Natalia Soikko]

Does JIRA save Commitment and Completed values for the sprint into DB?

If yes, what field names are? If not, how exactly value is calculated? I understand commitment means, but how the vales is calculated in jira.

I need values for the POWER BI.

Thank you!

[Alexey Matveev · Accepted solution]

Hello,

As far as I know it is calculated by issue history. The issue history in  the changegroup and changeitem tables. You need to take the start date of the sprint and find out the story points at that moment for each issue in the sprint. Then take the date the sprint was completed and find out in the history what was the story points for each issue in the Sprint.

[Natalia Soikko]

Hello Alexey,

Thank you!

Br

Natalia

[Alexey Matveev]

You are most welcome!