Board charts table reference

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. Field value calculation logic.
Velocity Chart Completed	BOARD_CHARTS_VELOCITY_CHART_COMPLETED	Velocity Chart completed value for sprint on the corresponding board. Field value calculation logic.

Data used for calculation of Board Charts table fields values

The table indicates the sources of data for calculating Board Charts table fields.

Thus, the data for corresponding fields calculating is specific for each individual board and its configuration. At the moment, the plugin doesn’t limit users in the amount of unloading, 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	Boards table data and configuration data for the boards functioning Issues table data Sprints table data Issues history changes (sprints, estimation field, status changes)
Velocity Chart Completed	Boards table data and configuration data for the boards functioning Issues table data Sprints table data Issues history changes (sprints, estimation field, status changes)

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.

Sprint State	Include estimation field values	Exclude estimation field values
Closed	Values of Issues that added to sprint before start/activation* date	All Issues Values that added to sprint after start/activation* date

Sprint State	Include estimation field values	Exclude estimation field values
Closed	Values of Issues that closed inside sprint at the completion date of sprint	Opened Issues Values at the completion date of sprint Values of Issues that closed outside of sprint