How to measure time between statuses and total cycle in Jira Service Management Cloud

[David Martínez López]

Hi community,

I need to measure the time a ticket spends between different statuses (e.g., from “Open” to “In Progress”, from “In Progress” to “Resolved”) and also the total time from creation to closure, using only native Jira Service Management Cloud features, without Marketplace apps.

I know SLAs can track time between two statuses, but that requires creating one SLA per transition and doesn’t provide a global view of time in all statuses or the full lifecycle.

Is there any native way to get reports or visualizations for this? Any workaround without external apps?

Thanks for any advice!

[Rahul_RVS · Accepted solution]

Hi @David Martínez López 

You can use Jira Rest API's to extract this data or if you would be interested in a mktplace app for this requirement, you can try out

Time in Status Reports 

With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options. 

The "Time in Status" report with Status grouping feature, and the "Time between Statuses" report can help to meet your use case of calculating the issue cycle times.

More details here.

Disclaimer : I am part of the app team for this add-on

[Anastasiia Maliei SaaSJet · Accepted solution]

Hi @David Martínez López 

I understand you might be looking for a native solution or a workaround, but I’d like to suggest a tool that was developed exactly for this kind of request—to easily measure transition times and cycle times without complex setups.

You might want to try Time Metrics Tracker: Time Between Statuses.

It allows you to configure specific status transitions and automatically calculates the duration for each issue.

Even if you aren't actively searching for an app, it’s worth a look because:

• It is free for teams of up to 10 users.

• There is a 30-day free trial for larger teams.

[Birkan Yildiz _OBSS_ · Accepted solution]

Hey @David Martínez López ,

Your best bet with native features is Jira Automation. However, it won't be retroactive, and it will be hard to maintain and require manual calculation.

I know you said you are not looking for a marketplace solution, but I am sharing a good fit, just in case. If you want to avoid the complex Jira Automation setup and get historical data instantly, Timepiece - Time in Status for Jira has all the features you asked for, and more.

Its Duration Between Statuses report allows you to measure both of the things you asked for in a single view:

You can calculate the duration between any statuses (e.g., from Open to In Progress).

You can define your Cycle Time by selecting your start and end statuses and calculate it using a custom calendar (to exclude nights/weekends).

The report calculates these durations automatically using your issue history, so it works for all your past tickets immediately.

You can check Timepiece on the Atlassian Marketplace. Hope this helps.

Full disclosure, I'm on the team that makes Timepiece - Time in Status for Jira.

[Danut M _StonikByte_ · Accepted solution]

Hi @David Martínez López,

Unfortunately, I don’t see an easy way to achieve this without using Marketplace apps, as Jira does not provide built-in reports or dashboard gadgets for measuring the time spent between statuses.

You could try using the Jira's reports like Time to Resolution or Control Chart, but I'm not sure of they help too much. 

Another possibility would be to try using Jira Cloud REST API to retrieve the issues along with their changelog events and then perform your own calculations—perhaps in Excel or using a script—to determine the time between statuses. However, this approach is quite complex and prone to errors.

If you reconsider using Marketplace apps, our Great Gadgets app can calculate this for you with minimal effort. 

Danut

[Fabian Lim · Accepted solution]

Hi @David Martínez López

Unfortunately, you can't out of the box.  You will have to look into  plugins such as time to sla, time in status, eazybi, and many others that have the capability to track what you need.

Regards,

Fabian

[David Martínez López]

Thank you very much, @Fabian Lim , for your response. We are currently using eazyBI, but I can’t find a clear option to generate that report. Could you please guide me on how to achieve this?

I really appreciate your help.

[David Martínez López]

I escalated the question to eazyBI’s AI, and it provided a configuration that was very helpful. I’m sharing it in this post in case it can help others. Many thanks to everyone for your responses.

Report Configuration by Status Category
Key difference from the previous report:
Instead of showing time for each individual status (e.g., "Open", "In Progress", "Resolved"), this report groups statuses by their categories.

Steps to create the report:

1. Start with a table view
2. Select the measure Average days in transition status
3. Deselect Issues created
4. Set the Transition Status dimension in Rows
5. Add the Transition Status dimension
6. IMPORTANT: Select the Category level from the Category hierarchy
   → This will automatically group statuses by category

Optional: Filter by specific categories

• Add Transition Status to Pages
• Select the desired categories:
  • To Do
  • In Progress
  • Done

Additional dimensions in Pages:

• Time: Last 12 months
• Project, Issue type, Priority, Assignee

[elita_kalane]

Hi @David Martínez López 

Thank you for posting the solution and I am happy to hear you found our AI colleague and found the response useful :) 

In addition, I wanted to let you know that there is an alternative solution as well, which may fit your use case even better. You could consider utilizing the Issue Cycle functionality (you can find the documentation here - https://docs.eazybi.com/eazybi/data-import/data-from-jira/issue-cycles) where in the import options you define the statuses you want to consider in your cycle to calculate time, and after you import the data, you will have multiple measures automatically created based on the statuses you defined. You can read more about it in the documentation page and also what measures become available. 

Best wishes,

Elita from support@eazybi.com