Time in Status report
The Time in Status report shows the total time an issue has stayed in each status.
Choose the Time in Status report;
2. Filter by the category you need;
3. Choose the time range for the data calculation;
Choose the issue range for the data calculation;
5. Choose the time format type that will be represented on the grid;
6. Get all the data on the grid as shown below.
The time in status data that is displayed on the grid is calculated in the following way:
For example, the task was in the To-Do status for 6 hours, then moved to the In Progress status. After a while, the task returned to the To-Do status and stayed there for 2 hours until it moved to another status. So, the time in the To-Do status for this task is 8 hours.
In the Time in Status report, below the column titles, the number of issues in each column, the total amount of time issues spent in each status, and the average value are calculated. The Total column performs the same calculations but is consolidated - based on all the data in the grid. This feature is available when you select the Table view of reports.
It is also worth noting that this calculation will not be displayed if you select more than 2,500 tasks.
The Summary Row option, typically located in the column header, is currently unavailable due to ongoing technical enhancements. If you require this feature, please reach out to our support team. They'll be able to activate the Summary Row specifically for your Jira instance.
Note. The average value is calculated based on issues with a time value greater than 0 in a certain status. That is, the sum of all time greater than 0 that a task has spent in the status divided by the number of tasks.
The report calculation in the Charts view occurs during the chosen period. It counts the total time of the sample tasks in statuses. For example, on the 24th of May, 3 tasks out of 4 were in To-Do status for 1h, 2h, 3h. That’s why the time in the To-Do status for the 24th of May is 1h + 2h + 3h = 6h
Here are a few use cases to learn more about the Time in Status report:
How to get the Issue Age data?
How to monitor time each employee spent on solving each task or issue?
Time in status per assignee using the Pivot table function.
How to display the Time in Status report for the current week only?