nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Natalia Soikko

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!

Accepted answers

Alexey Matveev

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.

All comments

Alexey Matveev

Hello,

Natalia Soikko

Hello Alexey,

Thank you!

Natalia

Alexey Matveev

You are most welcome!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-software

ms-powerbi