/
Time in Status Report and Status Transition Report

Time in Status Report and Status Transition Report

To create a Time in Status report, you need to combine any of the “Time in Status” fields in Report Builder Universal Report together with the “Changelog Status” field. To create a Status Transition report, you need to apply any of the “Transition Date” fields together with the “Changelog Status” field. The instructions below will show you the process.

 

Time in Status Measures.mp4

 

Use of "Time in Status" fields in Universal Report

Step 1: Setup the Report Scope

  1. Open the Universal Report in Report Builder.

  2. Select the desired project and scope. You can define the scope to include individual issues or larger sets of data.

image-20250120-164413.png

 

 

Step 2: Replace the Standard Status field

  • To analyze statuses accurately:

    • Replace the standard status field with Changelog Status.

    • This ensures all status changes (based on issue change logs) are retrieved within the defined scope, not only the current statuses.

 

 

Step 3: Add "Time in Status" fields

  • In the field selection panel, locate the "Time in Status" fields:

    • Sum of Time in Status: Total time spent in each status.

    • Average Time in Status: Average time issues spent in each status.

    • Median Time in Status: Median time across all issues in a status.

  • Additional options include reporting in 24/5 mode:

    • Reports either include all calendar days or focus on business days only (remember business days will be calculated as 8 hours, not 24 hours, that could be inaccurate for some use cases).

 

Step 4: Customize the Time Format

  • After adding the "Time in Status" field, you can choose the time display format:

    • Seconds, Minutes, Hours, Days, or Pretty Format (human-readable).

    • The Day and Pretty Format are influenced by your Jira Calendar Settings (remember business days will be calculated as 8 hours, not 24 hours, that could be inaccurate for some use cases).

Step 5: Add "Transition Date" field (Optional)

  • To track when issues transitioned between statuses:

    • Add the Transition Date field of ones available.

    • This highlights the specific dates when changes occurred, useful for understanding workflow timelines.

 

Step 6: Finalize and Analyze

  • Once fields are added:

    • Apply sorting, filtering, or grouping for further insights.

    • Export the report if needed for external sharing or further analysis.