In today's fast-paced world of Agile and hybrid project management, the end goal is to deliver value continuously and frequently; however, how often do we actually stop and think about how long each issue or ticket is 'stuck' in a single status? Tracking the duration in each stage of your workflow, for instance "To Do," "In Progress," "Review," or "Done", is more than a number, it's an indication of your team's efficiency. By tracking these transitions between statuses, teams can identify not only the bottlenecks and impediments, but also improve the workflow and make better data driven decisions to increase speed and quality of delivery.
Three Ways to Measure Time in Status in Jira
JQL & Issue History (Manual method)
Out of the box, Jira does not have a “time in status” field, but you can approximate it by using the Jira Query Language (JQL) and issue history.
The query is as simple as: status changed TO "X" DURING (...) to filter based on desired transitions.
You can also review the changelog from the issue and manually calculate timestamps.
This is a feasible method, but it's a lot of work and prone to human error when dealing with large numbers of issues.
Automation + Custom Fields
Automate instead of doing it manually:
Trigger rules as soon as an issue transitions.
Place a timestamp (e.g., "entered In Progress") in a custom field.
The next time the issue transitions, subtract the previous timestamp to get "time in last status."
This means you will have up-to-date metrics, and you won’t have to rely on the team to do this manually.
Jira REST API & Custom Scripting
If you are familiar with coding:
You can fetch a full history of status changes using the Jira REST API GET /rest/api/2/issue/{issueIdOrKey}/changelog
Then, you will be able to parse each change, calculate durations, and aggregate the data for dashboards or custom reports. This does give some flexibility to (custom) business logic and integrations.
Marketplace Apps (e.g., RVS Time in Status Reports)
If you're all about the plug-and-play simplicity and want apps from Atlassian Marketplace to do all the work for you, RVS Time in Status Reports (TIS) has the following:
A Status Transitions tab where you can see how long an issue was in each status
Assignee Transitions reporting, so you can assess individual performance
Export functionality (Excel, etc.) to analyze the data
This approach is helpful if you want something visual and ready-made, without having to reinvent the wheel.
The Real Benefits of Time in Status Tracking
Implementing time-in-status tracking is more than just a “nice to have.” It brings real value:
Time Insights
Identifying Bottlenecks
Enhanced Decision Making
Tracking Team Productivity
Improving Resource Allocation
Identifying Training Needs
Client and Stakeholder Transparency
Final Thoughts
Tracking the duration of status transitions in Jira goes beyond a simple success measure. When tracked effectively, it becomes a strong compass for ongoing improvement of your workflow. Whether you automate the tracking, use custom scripts, or a tool like RVS Time in Status Reports, the outcome is reduced delays, greater transparency, and shorter turnaround times that keep your projects flowing!. Schedule a call for more information.
Top comments (0)