Tracking transitional time

[Consuelo Nicoli]

Hi everyone,
Is it possible to track the time between one transition and another? I'll give you an example:
1. Now a task is in state A
2. at 3 pm I place it in state B
3. at 5pm I place it in state C

I want to track how much time passed between state C and state B (2 hours).

Thank you

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

The issue history records all changes, so you can see the time elapsed in there.

However, I think you might be asking for a more generalised "report on time in status for a load of issues".  Jira does not have anything built-in for that beyond "time it took to resolve the issue(s)" which does not differentiate between the to-do and in-progress type status, it only looks at the issue raised and issue resolved times.

Have a look in the marketplace for the apps that report on "time in status" - most of them give you excellent overview reports and allow you to drill down into the detail really easily.

[Valeriia_Havrylenko_SaaSJet]

Hi @Consuelo Nicoli  👋 
Welcome to the community!

For your needs I would recommend trying out our another add-on Time Between Statuses. The add-on is specifically designed to calculate dates between two Jira columns.

You can also set up highlights of values that exceed the permissible level, and in this case, you can receive issue and email notifications.

 Benefits:

• Identify Bottlenecks: Quickly see where issues are getting stuck in your workflow.
• Optimize Processes: Use data to streamline processes and improve efficiency.
• Enhanced Reporting: Gain deeper insights into your team's performance and workflow effectiveness.
• Improve Accountability: Make data-driven decisions to hold teams accountable and drive continuous improvement.
  
  

Add-on has 30-days trial version, free up to the 10 users and developed by my SaaSJet team.

---

Another option can be Time in Status add-on.

It generates 7 types of status reports, including a Time in Status report that shows how long an issue has been spent in each status (To do, In progress, On hold, Done, etc). You can choose the time format type that will be represented on the grid.

Add-on also has a 30-day free trial version and free up to 10 users. 
Please, let me know if you have any questions

I hope this helps 😊

[Gizem Gökçe _OBSS_]

Hello @Consuelo Nicoli ,

Welcome to the community!

Timepiece - Time in Status for Jira ,the oldest and leading "Time in Status" app in Atlassian Marketplace, which is developed by my team at OBSS, has a report type that will meet your need.  Our app is available for both Jira Cloud, and Data Center. 

Duration Between Statuses report type which shows the duration between two specific statuses. This report type also allows the user to exclude the times for "pause" statuses. 

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example, in the screenshots below, the Duration Between Status report shows the total monthly response and resolution times for each assignee in a project.

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 and you can get reports on your past issues as well.

Visit Timepiece - Time in Status for Jira to explore and enjoy a 30-day free trial to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

[Mehmet A _Bloompeak_]

Hi @Consuelo Nicoli

Welcome to the Atlassian Community!

There is no built-in solution for time in status info in Jira. If you prefer using a marketplace app, you can try Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

Here is the online demo link, you can see it in action and try without installing the app. For your case, you can have a look at Time in Status for Each Issue report (how much time passed between state C and state B is in fact the time passed in state B).

For further details, you can have a look at Status Time Reports How to Videos.

• This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, resolution time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

If you are looking for a completely free solution, you can try the limited version Status Time Reports Free.

If you have any questions, feel free to schedule a demo with us.

Hope it helps.

[Hannes Obweger - JXL for Jira]

Hi @Consuelo Nicoli

welcome to the community!

As Nic suggested, this is an area where many Jira users rely on apps from the Atlassian Marketplace to fulfil their status time reporting needs. 

If a Marketplace app is an option for you, I think you might like the app that my team and I are working on, JXL for Jira. 

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields - including all JSM-specific fields - much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called history columns that aren’t natively available, including time in [status], time between [status] and [status], and many, many more.

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

You may already know that you can trial any app for free for 1 month, so if an app is an option for you, perhaps try a few and see which one works best for you and your team!

Any questions just let me know,

Best,

Hannes