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.
Board Charts table description

Board Charts Table Description

The Board Charts table is designed to unload export chart information on for specific boards. A specific detailed list of fields that can be unloaded and exported, along with their description, is given provided in Tablethe 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.

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

Used for

calculation

Calculation of Board Charts

table fields values

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

calculating

is specific

for

to each

individual

board and its configuration.

At the moment

Currently, the

plugin

app doesn’t limit users

in

regarding the amount of

unloading

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

  • 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

Fields Values

The calculation of the Estimation field for calculating is determined by the board board’s estimation configuration.NOTE: only

Only numeric estimation custom field values

calculation is supported (

are calculated. Issue Count or Original Time Estimate

is

are not

computing)

computed.

Field The field values are calculated by analyzing based on the history of changes in the state of each individual Issue relative to the corresponding sprint’s start and completion dates of the corresponding sprint. 

Info

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.

Info

The board filter query can be defined in the corresponding section of the board configuration.

Info

The Issue status is determined by the presence of a value in the

“status”

status field. If the value equals

to

the

board

right-most column status

Issue mark as “closed”.Future

on the board, the Issue is marked as closed.

Info

The future sprints are not shown in this table because they are not supported by the board charts.

Info

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

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 fields values are described in the Tables below.

Values that are

The values included or excluded from the resulting fields of Velocity Chart Commitment

field valueNOTE: starting

are as follows:

Info

Starting from Jira version 8.7.0, the calculation is based on the sprint activation

date 

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

The values included or excluded from the resulting fields of Velocity Chart Completed

field value

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

  • Opened Issues Values at the completion date of sprint

  • Values of Issues that closed outside of sprint