Calculated Fields

BigQuery Connector for Jira allows exporting the data about the time issue spent in certain status and per assignee.

This is helpful, as Jira users do not need to build complicated calculations between several tables on the BigQuery side, and that is time-consuming. BigQuery Connector for Jira makes all the calculations automatically and allows to export ready-to-use data about Issue Time in Status and Issue Time by Assignee

 

Issue Time in Status

 

The available fields are presented in the table.

Duration in 24/7

DURATION_IN_NORMAL_HOURS

The sum of time in seconds a task spent in particular status. The time is counted 24 hours 7 days a week.

Formatted Duration in 24/7

DURATION_IN_NORMAL_HOURS_FORMATTED

Shows DURATION_IN_NORMAL_HOURS formatted seconds to hh:mm:ss

Duration in Business Days (24/5)

DURATION_IN_BUSINESS_DAYS_24H

The sum of time in seconds a task spent in particular status. The time is counted 24 hours 5 days a week (Monday-Friday).

Formatted Duration in Business Days (24/5)

DURATION_IN_BUSINESS_DAYS_24H_FORMATTED

Shows DURATION_IN_BUSINESS_DAYS_24H formatted seconds to hh:mm:ss

Duration in Business Hours/Days (8/5)

DURATION_IN_BUSINESS_DAYS_BH

The sum of time in seconds a task spent in particular status. The time is counted 8 hours 5 days a week (Monday-Friday).

Formatted duration in Business Hours/Days (8/5)

DURATION_IN_BUSINESS_DAYS_BH_FORMATTED

Shows DURATION_IN_BUSINESS_DAYS_BH formatted seconds to hh:mm:ss

Issue in Status Count

ISSUE_IN_STATUS_COUNT

Shows the number of times an issue was in the status

First Transition to Status

FIRST_TRANSITION_TO_STATUS

Shows the date and time the issue was transitted to the status for the first time

Last Transition to Status

LAST_TRANSITION_TO_STATUS

Shows the date and time the issue was transitted to the status for the last time

First Transition From Status

FIRST_TRANSITION_FROM_STATUS

Shows the date and time the issue was transitted from the status for the first time

Last Transition From Status

LAST_TRANSITION_FROM_STATUS

Shows the date and time the issue was transitted from the status for the last time

Issue Time by Assignee

 

The available fields are presented in the table.

Field Name

Field ID

Description

Field Name

Field ID

Description

Duration in 24/7

DURATION_IN_NORMAL_HOURS

The sum of time in seconds a task spent in particular status. The time is counted 24 hours 7 days a week.

Formatted Duration in 24/7

DURATION_IN_NORMAL_HOURS_FORMATTED

Shows DURATION_IN_NORMAL_HOURS formatted seconds to hh:mm:ss

Duration in Business Days (24/5)

DURATION_IN_BUSINESS_DAYS_24H

The sum of time in seconds a task spent in particular status. The time is counted 24 hours 5 days a week (Monday-Friday).

Formatted Duration in Business Days (24/5)

DURATION_IN_BUSINESS_DAYS_24H_FORMATTED

Shows DURATION_IN_BUSINESS_DAYS_24H formatted seconds to hh:mm:ss

Duration in Business Hours/Days (8/5)

DURATION_IN_BUSINESS_DAYS_BH

The sum of time in seconds a task spent in particular status. The time is counted 8 hours 5 days a week (Monday-Friday).

Formatted duration in Business Hours/Days (8/5)

DURATION_IN_BUSINESS_DAYS_BH_FORMATTED

Shows DURATION_IN_BUSINESS_DAYS_BH formatted seconds to hh:mm:ss