Sprints Table Description
The Sprints table is designed to export data related to sprints, including information such as the number of issues, estimations, and more. The specific list of fields that can be exported, along with their descriptions is presented in the table below.
Column Name | Column ID | Description |
Sprint ID | SPRINT_ID | Sprint unique ID in Jira database |
Sprint Name | SPRINT_NAME | Sprint name |
Sprint State | SPRINT_STATE | Sprint state (future, active, closed) |
Sprint Goal | SPRINT_GOAL | User-specified sprint goal This field is available for unloading on Jira versions 7.2.0 and higher. |
Sprint Activated Date | SPRINT_ACTIVATED_DATE | Actual start time of sprint in UTC This field is available for unloading on Jira versions 8.7.0 and higher. |
Sprint Complete Date | SPRINT_COMPLETE_DATE | Actual time of sprint completion in UTC |
Sprint Start Date | SPRINT_START_DATE | Sprint start time specified by user in UTC |
Sprint End Date | SPRINT_END_DATE | Sprint completion time specified by user in UTC |
Story Points Committed | SPRINT_STORY_POINTS_COMMITTED | Overall assessment of Issues (exclude subtasks) in Story Points that were added to the sprint and were not closed before they were added. |
Story Points Completed | SPRINT_STORY_POINTS_COMPLETED | Overall assessment of Issues (exclude subtasks) in Story Points that were added to the sprint and closed during sprint. |
Story Points Remaining | SPRINT_STORY_POINTS_REMAINING | Difference between Committed and Completed fields values |
Issue Sprints Count | ISSUE_SPRINTS_COUNT | Number of Issues (tasks and subtasks) related to sprint |
Data Used for Calculation of Sprints Table Fields Values
The table indicates the sources of data for calculating Sprints table fields.
Boards data and related data are not used in calculating Sprints table field values. Consequently, data displayed on Boards may differ from the results obtained when calculating Story Points Committed and Story Points Completed field values in the Sprints table.
Column Name | Sources of data |
Sprint ID | Sprints table data |
Sprint Name | Sprints table data |
Sprint State | Sprints table data |
Sprint Goal | Sprints table data |
Sprint Activated Date | Sprints table data |
Sprint Complete Date | Sprints table data |
Sprint Start Date | Sprints table data |
Sprint End Date | Sprints table data |
Story Points Committed | Sprints table data Issue history changes (sprints, estimation field, resolution changes) Actual Issues Estimation Values Actual Issues Sprints Values |
Story Points Completed | Sprints table data Issues history changes (sprints, estimation field, resolution changes) Actual Issues Estimation Values Actual Issues Sprints Values |
Story Points Remaining | Story Points Committed field value Story Points Completed field value |
Issue Sprints Count | Actual Issues Sprints Values Issues and issues links data |
Calculation of Story Points Committed and Story Points Completed Fields Values
The custom numeric field for calculating determined by the corresponding mapping in the admin panel.
The field values are calculated by analyzing the history of changes in the state of each individual Issue relative to the start and completion dates of the corresponding sprint.
You can track the history of changes for each Issue in the History tab.
To calculate the values, all Issues associated with a specific sprint are used.
Issues can be found in various projects and boards.
To see the current list of Issues for a specific sprint, use “Search for Issues” by Sprint value.
The Issue status is determined by the presence of a value in the Resolution field. If the value is not empty, status is defined as closed.
Calculation of Story Points Committed and Completed Fields Values
The values included or excluded from the resulting Committed and Completed fields values are described in the tables below.
The values included or excluded from the resulting Committed field value:
Sprint State | Include estimation field values | Exclude estimation field values |
Future | Opened Issues Actual Values | Closed Issues Values |
Active | Opened Issues Actual Values, Actual Values of Issues that closed in Sprint | Values of Issues that closed outside of sprint |
Closed | Opened Issues Values at the completion date of sprint, Closed Issues Values at the completion date of sprint | Values of Issues that closed outside of sprint |
The values included or excluded from the resulting Completed field value:
Sprint State | Include estimation field values | Exclude estimation field values |
Future |
| |
Active | Actual Values of Issues that closed in Sprint |
|
Closed | Closed Issues Values at the completion date of sprint |
|