Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I create a 'time in status' report in Jira Cloud? Edited

I would like to track how much time any type of issue spends in each of our issue statuses.

For example to answer the question: how much time does an average issue type = 'Bug' with the priority = 'Blocker' spend in the status = 'New' (and 'Registered' and 'In development', et cetera). I also need to keep track of the total time any ticket spent between entering the system as a 'New' ticket, and leaving the system with any of the 'Closed' statuses (such as 'Invalid' or 'Works for me' or 'Fixed' et cetera).

Can anybody point me to the right JQL documentation, or perhaps even share some of the code they use to run such a report in their Jira Cloud environment?

Frankly I'm a bit surprised this report isn't a standard feature of Jira. It's quite important to keep track of this stuff to improve the level of service offered year on year and find out which areas need the most improvement. I can only find addons for which I have to pay an extra subscription fee. But I guess it's possible to make this report myself? I've got no idea how, unfortunately.

5 answers

Hi@Mark den Uil 

At the current moment, it's not possible to get information about time in status using JQL code or using the built-in functionality of Jira Cloud.

You can obtain this data using the add-on like Time in status for Jira Cloud by SaaSJet.

It generates 3 types of reports at the moment:
- Status Count - shows how many times an issue has been in each status
- Transition Count - shows how many times an issue went from status to status
- Time in status - automatically determines for how long your issues had been staying in each status.
Also, you can export the data they need as a report in XLS or CVS format.

Hope it helps

Hello Mark,

Our team at OBSS created Time in Status app for this exact need. It is available for Jira Cloud, Server and Data Center.

Using Time in Status you can report how much time each issue spent on each status, each assignee or even each user group (useful for identifying bottlenecks in your process). You can also see the number of times each status or transition was used (very useful for inspecting reopen counts). Finally you can also create reports on the dates of each issue status transition.

You can produce reports based on the default 24/7 calendar or define your own business calendars with custom workdays and working hours.

Also add system or custom fields as columns to your report and customize the view format of durations.

All data can be exported as XLS, XLSX, CSV.

Emre Toptancı


Hi @Mark den Uil 

With new features added to the Time in status for Jira Cloud by SaaSJet, you can easily track how much time any type of issue spends in each of our issue statuses.

Besides Time in Status report, you can measure:

  • Assignee Time
  • Average Time
  • Status Entrance Date and much more.

Filter issues by:

  • Project
  • Filter
  • Report
  • Label
  • Sprint
  • Assignee
  • also by issue creation, update, and resolution date.

Moreover, you can view all of the reports as charts (Pie, Bar and Area Charts).

You can exclude breaks, non-working hours or holidays and create multiple calendars.

Hope, that the new Time in Status for Jira Cloud will help you to create reports you need.

I don't understand what is the point of this field in JIRA cloud then which comes built-in out of the box. What does this do? I created a field using that type but it doesn't do anything. I was hoping that it would have some configuration to make it work but nada. What is the point of that field? See the screenshot below. 

What am I missing? 



Screen Shot 2021-03-04 at 1.39.31 PM.png


If you would be interested in a ready made solution, you may want to try out our plugin,

Agile Tools : Epic Tree & Time in Status 

It provides 3 major functionalities in one add-on

  • More than 7 types of Time in Status Reports
    • Time in Status
    • Time with Assignee
    • Time in Status with Assignee
    • Time with Assignee per Status
    • Status/Assignee Count
    • Multiple Transition Reports
  • Epic Hierarchy / Sum Up (Standard Jira Hierarchy Epic -> Story -> SubTask)
  • Link Hierarchy / Sum Up (Hierarchy based on your issue link, upto 10 level deep)



Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you