Board Charts Table Reference

Owned by Liubov Topchyi
Last updated: Nov 30, 2023 by Liliia Ostrovska
3 min read

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.

 

Values that are included or excluded from the resulting Velocity Chart Commitment field value

NOTE: starting from Jira version 8.7.0, the calculation is based on the sprint activation date 

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

Values that are included or excluded from the resulting Velocity Chart Completed field value

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