Skip to main content
Skip table of contents

Average Time Report

The Average Time Report provides insights into the duration that Work Items remain in a particular state over a defined period.

  1. Choose the Average time report;

Знімок екрана 2024-10-20 о 06.16.49.png
  1. Filter by the Query you need.

Знімок екрана 2024-10-20 о 06.19.11.png
  1. You have the option to choose the time granularity: hourly, daily, weekly, monthly, or quarterly.

Знімок екрана 2024-10-20 о 06.36.21.png
  1. Choose the Work Items range;

Знімок екрана 2024-10-20 о 06.29.54.png
  1. Choose the Time ranges;

Знімок екрана 2024-10-20 о 06.32.01.png
  1. Choose a Format type that will be represented on the grid.

Знімок екрана 2024-10-20 о 06.33.16.png

On the Charts, you can view the average duration that items have remained in specific states over a designated period. For instance, on August 21st, tasks were in the To-Do state for 0.73 business decimal days and in the New state for 0.45 business decimal days. This results in a cumulative total of 1.18 business decimal days for the states on August 21st.

Знімок екрана 2024-10-20 о 06.24.01.png

How does the calculation of the Average time occur?

image-20240102-150122.png

The picture shows the logic of calculating the Average time.

  1. We count the number of tasks that have been in a particular status (To-Do status in this case) (green line),

  2. Then, sum up the time spent on these tasks (blue line). We take into account only those tasks that have been in the status.

  3. Divide the total time by the number of tasks. (1/2)

This is how the calculation of each value on the grid is occurring. 

💡 Key Insights of Average Report:

  • Bottleneck Detection and Process Improvement: Average Report in Azure DevOps allows you to quickly identify where work items are getting delayed in specific states, such as "To-Do" or "In Progress." This insight helps in streamlining processes and reallocating resources to clear bottlenecks, improving overall efficiency.

  • Performance Evaluation: Average Time Data helps in refining sprint planning, ensuring that high-priority tasks are completed on time, and making informed decisions about resource allocation.

  • Accurate Forecasting and Stakeholder Reporting: The report provides historical data that project managers can use to predict future timelines more accurately. It also offers clear, visual representations of time spent in each state.

If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net

Haven't used this add-on yet? Try it now >>>Time in State for Azure DevOps

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.