Board Charts table description
The Board Charts table is designed to unload chart information on specific boards. A specific list of fields that can be unloaded and their description is given in Table.
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
Calculation of Velocity Chart Commitment and Velocity Chart Completed fields values
Estimation field for calculating determined by the board estimation configuration.
NOTE: only numeric estimation custom field values calculation is supported (Issue Count or Original Time Estimate is not computing).
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 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.
Issue status is determined by the presence of a value in the “status” field. If the value equals to the board right-most column status Issue mark as “closed”.
Future sprints are not shown in this table because they are not supported by the board charts.
The pair of ‘board and sprint’ is unique for the Board Charts table and is intended to display all values for this pair.
Calculating Velocity Chart Commitment and Velocity Chart Completed fields values
Values that are included or excluded from the resulting Velocity Chart Commitment and Velocity Chart Completed fields values are described in the Tables below.