Versions Compared

Old Version 1

changes.mady.by.user Nataliya Timoshina

Saved on

compared with

New Version 2

changes.mady.by.user Liliia Ostrovska

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Sprints table description

Table of Contents
minLevel1
maxLevel6
outlinefalse
typelist
printablefalse

Sprints Table Description

The Sprints table is designed to unload export data about sprints and related data (related to sprints, including information such as the number of issues, estimations, etc.). A and more. The specific list of fields that can be unloaded and their description are exported, along with their descriptions is presented in the Table: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.

Field value calculation logic.

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.

Field value calculation logic.

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

Used for

calculation

Calculation of Sprints

table fields values

Table Fields Values

The table indicates the sources of data for calculating Sprints table fields.

Boards data and related data are not used in

the process of

calculating Sprints table field values.

Thus

Consequently,data

presented

displayed on Boards may

not match with the data

differ from the results obtained when calculating Story Points Committed and Story Points Completed field values

of

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

Fields Values

The custom numeric field for calculating determined by the corresponding mapping in the admin panel. 

Field 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. The

Info

You can track the history of changes for each Issue

is tracked

in the History tab.

To calculate the values, all Issues associated with a specific sprint are used. NOTE: issues

Issues can be found in various projects and boards.

In order to 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".

Calculating

Calculation of Story Points Committed and Completed

fields values
Values that are

Fields Values

The values included or excluded from the resulting Committed and Completed fields values are described in the Tables tables below.

Values that are

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

Values that are

The values included or excluded from the resulting Completed field value:

Sprint State

Include estimation field values

Exclude estimation field values

Future


  • All Issues Values

Active

Actual Values of Issues that closed in Sprint

  • Opened Issues Actual Values

  • Values of Issues that closed outside of sprint

Closed

Closed Issues Values at the completion date of sprint 

  • Opened Issues Values at the completion date of sprint

  • Values of Issues that closed outside of sprint