Calculated Fields
- Nataliya Timoshina
- Liliia Ostrovska
Looker Studio Connector for Jira allows you to export data about the time issues spent in certain statuses and per assignee.
This is helpful for Jira users as they don’t need to perform complicated calculations across multiple tables on the Looker Studio side, which can be time-consuming. Looker Studio Connector for Jira makes all the calculations automatically and allows you to export ready-to-use data about Issue Time in Status and Issue Time by Assignee
Issue Time in Status
The following fields are available:
Field Name | Field ID | Description |
|---|---|---|
Duration in 24/7 |
| 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 |
| Shows |
Duration in Business Days (24/5) |
| 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) |
| Shows |
Duration in Business Hours/Days (8/5) |
| 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) |
| Shows |
Issue in Status Count |
| Shows the number of times an issue was in the 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 |
| Shows the date and time the issue was transitted to the status for the last time |
First Transition From Status |
| Shows the date and time the issue was transitted from the status for the first time |
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 following fields are available:
Field Name | Field ID | Description |
|---|---|---|
Duration in 24/7 |
| 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 |
| Shows |
Duration in Business Days (24/5) |
| 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) |
| Shows |
Duration in Business Hours/Days (8/5) |
| 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) |
| Shows |