Average Time in Status in Sprint

Step 1: Add a Data Source. In our example, we’ve filtered our demo project “AQUA” and disabled the date range to view all previous sprints.

Step 2: Select the 'Time in Status' metric and specify the status "Review".

Step 3: Switch from Sum to Average calculation. Average calculation provides insight into typical durations, mitigating the impact of outliers and offering a clearer understanding of overall task progression.

Step 4: Choose ‘Sprint’ for the ‘Display by’ field and add the Sprint Board you want to analyze.

Step 5: Turn on the Target section and opt for a Fixed target.

Step 6: Select “Per x-axis item” as the target type and set the value of your choice. In our sample report, it is 2 hours.

Step 7: Specify that exceeding 2 hours in the chosen status on average is considered undesirable by choosing "exceeding is Bad".

Step 8: (Optional) Under More Settings, add a warning threshold of your choice as an early indicator of approaching the target.

Step 9: Optional) Under More Settings, set a custom target label to "Max. 2 h".

Detailed image for Step 2:

In the sample report we have used status "Review", but you have the flexibility to select each status of interest, such as "In Progress" or "Testing," allowing you to easily identify bottlenecks in each step of your workflow.