How to track amount of time spent in status

Hello!

My company is running Jira Cloud and we are trying to improve our reporting and metrics.

We are trying to determine:

1. How long each ticket has spent in each particular status 

2. Amount of times a ticket was sent to a particular status. (Not just the tickets currently in a particular status, but if a ticket has ever been in a certain status)

Essentially, we are hoping to understand how long a ticket is spending in Pull Request and also (separately) how many times a ticket has been reopened (per epic, per assignee, etc).

Is there a plugin or a report/query I haven't tried that can help with this?

Any help would be greatly appreciated. Thanks!

8 answers

I think it is ridiculous that such a simple item isn't available out of the box

Branden,

Thanks for your reply! While helpful in a way, the information I really gleamed from this is that there is currently no solution for Jira Cloud.

Both Time in Status and Jira Suites Utilities appear to be Jira Server only solutions. While Jira Charting plugin does come free and pre-installed on Jira Cloud, the documentation points out in step three that "(Optional) Install JIRA Suite Utilities Plugin, so that you can monitor each issue time in a status." I will continue to play with the Average Time in Status plugin, however I fear that it won't satisfy the particular needs of my organization and asks from leadership. 

Hope you have a great weekend,

Dana

 

@Dana GouldHi Dana, Hope you are doing great, I was looking for this same need and couldn't find any other solution.  Wanted to check with you if you were able to capture Time Spent in each Status in some way for Cloud Version.

 

Thanks,

Nik

I am looking for the same solution @Dana Gould. It would be great to hear about your progress with this.

Kind Regards

Nida

Hello there

Now new add-on is available — Time in Status for Jira Cloud. It solves the problem of calculating a time issue spends on each status.
This add-on is the good way to get a helicopter view,  find out bottlenecks and unproductive delays in your processes.

You can get more information and download the add-on at the Atlassian Marketplace.
Regards

Ray Foulk I'm New Here Jan 09, 2019

This plugin ultimately did the trick for me.  This should be built-in to JIRA.

I'd like to try it but will never pay 2.50€ per User for that. The pricing for Add ons is ridiculous, especially for a BASIC function like this.

Like 5 people like this

Hi @Dana Gould! I'm in desperate need of exactly this. Did you finally find a solution? If yes - please share!    

@Dana Gould and @Steve Jones Please let me know as well. Thanks.

This is exactly the information we are after as well.

 

Key reason is that it would help to identify bottlenecks, and also the impact of improvements that we make to address these resource issues.

 

We achieved a similar report before by creating an app that would download this information from the Jira API and to a Mongo DB, and then another app would parse the DB to get the results as @Dana Gould has raised.

It would be nicie if there was a default way in Jira to get this information.

1 vote

Hi Dana,

There is an add-on by OBSS called Time in Status that may be of assistance and you can create reports based on issue creation date. In addition you may also want to try the JIRA Suites Utilities in conjuction with the Average Time in Status gadget.

In addition there is another communities post that provides some hints other users have found when using the Average Time in Status gadget.

Let me know if that helps.

Cheers!

Branden

Hi Branden,

Link to "JIRA Suites Utilities" is broken.

Thanks

Did you try "Time Reports" from "Prime Timesheet"?

There is a Cloud version and it seems to fit your needs.

Greetings.

Antonio.

I believe the Control chart would be able to tell you the time its spent on each status.  Is that what you are looking for in #1?

Like 1 person likes this

Need this feature in JSD server too please. Basic functionality again. 

We have time stamps for each transition but no report? Seems weird

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Wednesday in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

47 views 0 2
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you