Time in Status - to track time spent in a status

Edgaras Baumila

Hello. I've been having trouble setting up post functions for a custom field "Time in Status". Basically we want to track the time spent in a status and accumulate it every time it switches. Scenario:

- A transition happens from "Ready for Test" to "In testing"
- During this transition, we want to track how long did the issue stay under the "In Testing" status
- If a transition happens from "In Testing" to anything else, the time tracking stops
- If at any point it transitions back to "In Testing" it starts tracking again.

Which post functions should I use to achieve this?

Emre Toptancı [OBSS]

Hello @Edgaras Baumila

The raw data you need for this report is available in each issue's history but Jira does not give this to you as a ready-to-use report.

Measuring this manually is expensive to build/maintain (needs to be put into every workflow), very hard to scale (a separate custom field for each measurement), and does not work for past issues.

I suggest you use a marketplace app built for this purpose.

 

If you are OK with using a marketplace app for this, our team at OBSS built Timepiece - Time in Status for Jira for this exact need. It is available for Jira Server, Cloud, and Data Center.  

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows, you don't create custom fields and you can get reports on your past issues as well. It supports both Company Managed and Team Managed projects.

Time in Status mainly allows you to see how much time each issue spent on each status and on each assignee.

       

The app has Consolidated Columns feature. This feature allows you to combine the duration for multiple statuses into a single column and exclude unwanted ones. It is the most flexible way to get any measurement you might want. Measurements like Issue Age, Cycle Time, Lead Time, Resolution Time etc.

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer (organization) or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.

And the app has a REST API so you can get the reports from Jira UI or via REST.

  

Using Time in Status you can:

• See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
• Calculate averages and sums of those durations grouped by issue fields you select. (For example, see average InProgress time per project and per issue type.)
• Export your data as XLS, XLSX, or CSV.
• Access data via REST API. (for integrations)
• Visualize data with various chart types.
• See Time in Status reports on Jira Dashboard gadgets

Timepiece - Time in Status for Jira

EmreT