Time in State for Calculating Azure DevOps Work Item States

DEMO SUPPORT

Time in State by SaaSJet helps you control the time Work Item spent in the workflow at each state. Find problem areas and positive dynamics by chart report and monitor time spent at the Work Item panel.

Take time tracking in Azure DevOps to a new level - ensure that your team stays on track and delivers quality results faster. Time in State supports all custom states and Azure DevOps processes, such as Basic, Agile, Scrum, CMMI.

🚀 What is Time in State?

Time in State is your all-in-one tool for analyzing workflow in Azure DevOps. It enables you to:

1. Detailed Time Reports

Get reports on:

• Time in State – Analyze how long Work Items stay in each stage of the workflow.
• State Count – See how many times a Work Item transitions through specific states.
• Transition Count – Track transitions between states.
• Average Time – Understand average duration for improved planning.

2. Customizable Columns

Control your report views effortlessly:

• Add or remove statuses to adjust calculations.
• Fine-tune the data displayed for clearer insights.

Your total time metrics will adapt dynamically to match your selected statuses.

3. Visual Data Representation

Generate insightful reports with charts to make data-driven decisions:

• Pie Charts
• Bar Charts
• Area Charts

4. Smart View Mode

Focus on what matters most with Smart View, ensuring every detail is captured at a glance.

5. Export Functionality

Export data to Excel for additional analysis, such as calculating Cycle Time, Lead Time, and other critical metrics.

Use Case:

A company follows a sprint lifecycle for each user story as it progresses from development to testing to production. The project manager John wants to track how long this process takes.

Steps:

1. Go to Boards
2. Choose a report: Select one of the available reports: Time in State, Average Time, State Count, or Transition Count (all reports are available by grid or graphs chart). Let's use Time in State to track how long tasks stay in each stage of the workflow and Query all items.
3. Set Work Items range and Time range for the calculation.
4. Enable Smart View for better data clarity.
5. Choose a right Calendar to ensure that only the team's working hours are included in the report.
6. In Columns, control what Items are displayed in the report.
7. Export the report to calculate cycle time, lead time and other metrics.

Data visualization in charts

Get a visual representation of time spent in different states for Work Items by generating state reports in graphical format. Evaluate individual Work Items by creating dedicated charts for each one.

There are 3 types of charts available to you: Area, Bar, and Pie charts

Resources & Support

Explore our Documentation for detailed setup and usage guides.

Check out inspiring Use Cases, such as:

• How to calculate Work Item age in Azure DevOps
• Tracking Cycle Time in Azure DevOps
• Monitoring individual assignees' Work Items

Get help at https://saasjet.atlassian.net/servicedesk/customer/portal/1 or email support@saasjet.com.

Feature requests

We love to hear from you! Is there a feature you’ve been waiting for? Send us a Feature Request in our support center.

SaaSJet Blog

Interesting and informative articles about the app, use cases, etc., and special announcements on our blog at https://saasjet.com/blog/