Board Charts Table Reference
- Liliia Ostrovska
Board Charts Table Description
The Board Charts table is designed to export chart information for specific boards. A detailed list of fields that can be exported, along with their description, is provided in the table below.
Column Name | Column ID | Description |
Board Id | BOARD_CHARTS_BOARD_ID | Board unique ID in Jira database |
Board Name | BOARD_CHARTS_BOARD_NAME | Board name |
Sprint Id | BOARD_CHARTS_SPRINT_ID | Sprint unique ID in Jira database |
Sprint Name | BOARD_CHARTS_SPRINT_NAME | Sprint name |
Sprint State | BOARD_CHARTS_SPRINT_STATE | Sprint state (active, closed) |
Sprint Activated Date | BOARD_CHARTS_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 | BOARD_CHARTS_SPRINT_COMPLETE_DATE | Actual time of sprint completion in UTC |
Sprint Start Date | BOARD_CHARTS_SPRINT_START_DATE | Sprint start time specified by user in UTC |
Sprint End Date | BOARD_CHARTS_SPRINT_END_DATE | Sprint completion time specified by user in UTC |
Velocity Chart Commitment | BOARD_CHARTS_VELOCITY_CHART_COMMITMENT | Velocity Chart commitment value for sprint on the corresponding board. |
Velocity Chart Completed | BOARD_CHARTS_VELOCITY_CHART_COMPLETED | Velocity Chart completed value for sprint on the corresponding board. |
Data Used for Calculation of Board Charts Table Fields Values
The table indicates the sources of data for calculating the Board Charts table fields.
Thus, the calculation of data for corresponding fields is specific to each board and its configuration. Currently, the app doesn’t limit users regarding the amount of data that can be exported, in contrast to how it is described in the official Atlassian documentation for Velocity Charts.
Column Name | Data sources |
Board Id | Boards table data |
Board Name | Boards table data |
Sprint Id | Sprints table data |
Sprint Name | Sprints table data |
Sprint State | 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 |
Velocity Chart Commitment |
|
Velocity Chart Completed |
|
Calculation of Velocity Chart Commitment and Velocity Chart Completed Fields Values
The calculation of the Estimation field is determined by the board’s estimation configuration.
Only numeric estimation custom field values are calculated. Issue Count or Original Time Estimate are not computed.
The field values are calculated based on the history of changes in the state of each Issue relative to the corresponding sprint’s start and completion dates.
The history of changes for each Issue can be tracked in the History tab.
To calculate the values, all Issues associated with a specific board filter are used. The list of sprints for a specific board is also determined by these Issues.
The board filter query can be defined in the corresponding section of the board configuration.
Calculating Velocity Chart Commitment and Velocity Chart Completed Fields Values
The table below describes the values that are included or excluded from the resulting fields of Velocity Chart Commitment and Velocity Chart Completed.
The values included or excluded from the resulting fields of Velocity Chart Commitment are as follows:
Sprint State | Include estimation field values | Exclude estimation field values |
Closed | Values of Issues that added to sprint before start/activation* date |
|
The values included or excluded from the resulting fields of Velocity Chart Completed are as follows:
Sprint State | Include estimation field values | Exclude estimation field values |
Closed | Values of Issues that closed inside sprint at the completion date of sprint |
|