nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to track amount of time spent in status

Dana Gould

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!

Accepted answers

All comments

somethingblue

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 Suite Utilities in conjunction 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

Dana Gould

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

nikhil.shrivastava

@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

Daniel Serodio

Hi Branden,

Link to "JIRA Suites Utilities" is broken.

Thanks

unknown

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

Terrence Joe

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.

Qumar

@Dana Gould and @[deleted]Please let me know as well. Thanks.

Antônio Duarte_wod7u4

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

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

Greetings.

Antonio.

Pramod Karthikeyan

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?

Trish_yrbkkh

Nida Rashid

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

Kind Regards

Nida

Dave Yost

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

Ray Foulk

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

Saad_qk4klw

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

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

Saad_qk4klw

Is there a request raised with JIRA for a solution on this?

Emre Toptancı [OBSS]

Hello @Dana Gould

I am happy to inform you that the original Time in Status app by OBSS now has cloud support:

Our app creates reports on how much time each issue spent on each status, assignee or user group.
Number of time each status or transition was used.
View durations in days, hours, minutes, etc.
Include issue fields in your report.
Export data as CSV, XLS or XLSX.
Calculate time or count averages, grouped by multi level issue fields that you select.
Define your own business calendars.

We now have Server, Data Center and Cloud options.

Pramod Karthikeyan

You can find the time spent on status by going to Report -> Control Chart -> select the status you want to see -> then identify the story number you want the time for ; It will show you the time spent on each status per story.

Stefanie Jamison_0kd76n

This may work for the first question

Reports > Time Reports > Report Drop Down Menu > Time in Status

I created a filter, modified the date range, and added additional status categories to get all the status time information I needed.

Paige_Williams

Where were you able to find this menu? I do not see "Time Reports" within the project reports dashboard

Andriy Zhdanov

Hi Paige,

Please check https://primetimesheet.atlassian.net/wiki/spaces/KB/pages/148701185/Where+can+I+access+Report+in+Jira+Service+Desk+or+in+Next+Gen+project if it helps.

Thank you.

Paige_Williams

I am using Jira Software, not Service desk unfortunately

Marina Veselić

Is it possible to create an advanced JQL using keyords like WAS and DURING?

Something like:

status was "Waiting for customer" DURING (-1w , -1w) and status = "Waiting for customer" and updated<-1w

https://confluence.atlassian.com/display/JIRA044/Advanced+Searching

Cheers,

Marina

Logan Clemons_ur2682

It really is. Developers ask me for this all the time, and every time, I can't believe how difficult it is to accomplish something that should be so simple.

unknown

There's a standard jira plugin available by atlassian - Jira Charting - https://ecosystem.atlassian.net/wiki/spaces/JCHART/overview

It provides chart widgets for time in status.

Jonathon S

Time/Days in Status is a very common request so I spent a little time ironing out a reasonably simple solution. This will provide a dedicated "Days in Status" field. It does require an add-on, but it's the free version of Automation for Jira. This best suits Jira Server, but does work on Cloud as well. Just be aware that the free of version of the cloud add-on has a monthly limit on rule executions.

Quick, easy, and FREE way to create a "Days in Status" field for Jira Server or Cloud

Dana Gould_grcpeh

Hello! I actually moved companies which is why I unintentionally forsaken this thread. At my new company, we are still looking at ways to measure this information. We looked at the Time in Status plugin by OBSS, but so far find that it runs on a 24 hour clock and hasn't been that useful or helpful.

What we have been moving more and more towards is Jira Service Desk and using the Cycle and Lead Times along with the SLA other other reporting functionality that comes with this. Another additional pro is that the customer vs "agent" functionality has added a nice facelift to our intake process. Some cons have been the customer vs agent functionality in terms of additional training, start up time, and trouble shooting. Also the additional cost of another Atlassian program that charges per user (customers are free, but you pay per agent and any JSD plugin charges you based on how many Jira users you have).

The time in status mentioned in the sub-thread above is JSD-specific and looks like it could add even more granularity.

Emre Toptancı [OBSS]

Hello @Dana Gould ,

I wish you success in your new company. I also want to correct a misunderstanding.

Time in Status by OBSS does not only work on a 24 hour calendar. You can define multiple custom calendars, each with its own working days, working hours and time zone.

EmreT

Logan Clemons_ur2682

This code is very rough, but this is solution I came up with for my company. I capture the date the issue was created, the day it moved into acceptance status, and then calculate whether or not it met the SLA based on (acceptance status - open status). It also calculates based around weekends. You can plug in essentially any status and find out the status to status time, but it's a huge pain and building metrics off this script is essentially impossible.



import com.atlassian.jira.component.ComponentAccessor
import java.sql.Timestamp
import java.time.DayOfWeek
import java.text.SimpleDateFormat
import com.atlassian.jira.issue.IssueManager
import com.atlassian.jira.issue.Issue;

def myIssue = issue.getKey()
Issue issue = ComponentAccessor.getIssueManager().getIssueObject("$myIssue")

def workingDays = 0

String date = new Date().format( 'yyyy-MM-dd' ).toString()
SimpleDateFormat sdf_cDate = new SimpleDateFormat("yyyy-MM-dd")
Date cDate = sdf_cDate.parse(date)
Timestamp timestamp = new Timestamp(cDate.getTime())

def acceptance = ComponentAccessor.getChangeHistoryManager().getChangeItemsForField(issue, "status").find {
it.toString == "Acceptance" 
}?.getCreated()

def startDate = (issue.getCreated() as Timestamp).toLocalDateTime().toLocalDate()
def currentDate = (timestamp as Timestamp).toLocalDateTime().toLocalDate()

def weekend = EnumSet.of(DayOfWeek.SATURDAY, DayOfWeek.SUNDAY)

if (acceptance) {
def acceptanceDate = (acceptance as Timestamp).toLocalDateTime().toLocalDate()

if (acceptanceDate.isBefore(startDate)) {
return null
}

while (startDate.isBefore(acceptanceDate) || acceptanceDate.equals(startDate)) {
if (!(startDate.dayOfWeek in weekend)) {
workingDays += 1
}

startDate = startDate.plusDays(1)
}
}

if (!acceptance) {
if (currentDate.isBefore(startDate)) {
return null
}

while (startDate.isBefore(currentDate) || currentDate.equals(startDate)) {
if (!(startDate.dayOfWeek in weekend)) {
workingDays += 1
} 

startDate = startDate.plusDays(1)
}
}

Claire Kemp_eozkyc

Jarrod D

Hi @Jonathon S - we are looking into this and would like to review how you accomplished this; however we cannot view your confluence page.

Anthony San Juan

I wonder if there are still plans around this on 2020...

Claudiu_Andrei_Sbarnea

interest here as well.

Aaron Geister

Will this app work in conjunction with being able to query time in status for an automation with Automation for Jira?

I am trying to query the amount of time our tickets stay in a closed status so I can move them to an archive project so we keep out instance cleaned up. Unfortunately I have hit a big curb with not being able to query the amount of time tickets have been in closed status thus an automation to move these items will not work. I want to move tickets that are in a closed status for 3 months..

Does anyone know of a way to query this?

Janene Hoffmann Uher

Jonathan, your site is secure; therefore we cannot access the content in your link.

Eugene Yasiuchenko

We've faced with the same problem/need in our company. The best FREE solution in the Market - is 'Timentify' plugin: https://marketplace.atlassian.com/apps/1221604/timentify?hosting=cloud&tab=overview

It's not yet offering extensive reports, but it's ideal for getting an instant info for a given issue. Using this one. It does exactly what we need. Can't wait for the reporting feature.

Louise Hall

Thanks Eugene. How do you use this plugin? I've installed it but what next?

Mehmet A _Bloompeak_

You can use Status Time add-on. It generates status time report based on your working calendar.

If you are looking for a free solution, you can try Status Time Free.

unknown

This is only for resolved issues. Not issues currently in flight.

Rahul_RVS

Hi All

You may want to try out the plugin, Agile Tools : Epic Tree & Time in Status

It provides 3 major functionalities in one add-on

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
Link Hierarchy

Epic Hierarchy Screen_Server_Latest.PNG

Craig Cockburn

This is absurd. A kanban tool where you can't readily see processing time per state.

Rather than another jira plug in how about just buying leankit which is a kanban tool, interfaces to jira and has reports like this out of the box including tickets going backwards, another desired feature in jira

Mukama_j269wb

This is way back. But I hope you can respond.

What did you query exactly.

Take for instance I want to measure how much time it takes to transition from "to do" to "in progress"

Shailja Ginoria

Hi, for the status time free add on, how can we access the data in a report or see the report in the list view for multiple issues to export the information?

Mehmet A _Bloompeak_

Hi @Shailja Ginoria ,

In the free version, reporting (list view for multiple issues) is available but it is limited to 10 issues. For the full list, you need Status Time app.

I can have a session and can explain the usage of the app details in a live demo. Please contact us over support@bloompeak.io.

CHERI C

I’m in the way back machine too!

I’m trying to measure how much time all issues within a certain period of time, spent in each status so I can find bottlenecks and measure remediation.

Michael Boumansour

@Mukama and @CHERI C , I have a free tool that is capable of exactly what you both need to do. It's called the Enhanced Jira Query Tool. It is a Google Sheets application that leverages the Jira REST API to retrieve data from Jira. It can retrieve any field and its respective properties from Jira. It also has special derived fields not available in Jira such as time in status, cycle/lead time, working time, waiting time, and unplanned work to name a few. You can find the tool along with other free tools I have created on the Agile Creatives Tools page. There is a demo video and usage guide for all the tools. I have also created a training video on Udemy for the Enhance Jira Query Tool. Here is a coupon that will allow you to enroll in the course for free for the next 3 days. I hope this helps you both. Please let me know if you have any questions.

Cheers!

Mike

Daniel Eads

Hi everyone,

In the interest of brevity, I’ll mention that there are many resourceful solutions using scripts / spreadsheets scattered around the thread. If you have time and are interested in scripted solutions, please have a look at some of the options provided by other clever Jira users.

Jira’s built-in reporting functionality offers what we believe is the necessary featureset for the vast majority of teams. While this may not address the entire set of features your team may want, we believe the core product addresses the needs of most teams while offering the ecosystem the ability to extend Jira. Many marketplace apps exist - both free and paid - that add a range of features to Jira’s reporting capabilities. I encourage you to take a look at the options to consider what most fits your team’s needs:

Additionally, if you are on Jira Cloud Premium or Enterprise and interested in connecting other BI tools such as Tableau to Jira’s data, please check out the Early Access program for the Atlassian Data Lake.

Cheers,
Daniel | Atlassian Support

Bill Sheboy

Hi @Daniel Eads

What is the purpose of having an indicator for "Atlassian Recommended" answers to questions which can displace the voting provided for the community for other answers?

That mechanism seems redundant and to violate the spirit of a community-based support forum. Thanks for any information you can provide on this feature.

Best regards,

Bill

Daniel Eads

Hi @Bill Sheboy , you can read more about how we use this indicator on its announcement post here. In short, we want to make sure that highly-viewed threads have clear, helpful, and complete solutions as close to the top as possible. Data for this question indicates there were problems for folks finding information they were after (many people clicked "No" on the "Was this helpful?" banner).

Bill Sheboy

Thanks for the explanation, @Daniel Eads Although I have never associated that "Was this helpful?" banner with any specific posting. It seems to appear when the page paints, regardless of anything changing, or not changing, on a page and so probably cannot be used to accurately inform any selection of a recommendation. The voting seems a much more accurate and targeted method of identify valuable information.

Best regards,

Bill

Almut Jenk

This can be done in Basic Search and solved it for us:

statusCategoryChangedDate <= -3d AND status = "open"

statusCategoryChangedDate <= -5d AND status = "in progress"

Notes:

Select "More than X days"

Workflow needs to switch between to do and in progress status categories (white and blue)

Anthony Martin_7utbwl

2021, still not available. Still ridiculous.

Kiran Kumar Doddi

Board Settings -> card Layout -> at the bottom you will find Days in column

Hope this helps in knowing the time spent by each ticket in the workflow/column

Rich Nuzzi

Kiran, yes, this is true, but not very useful. It only shows three colored dots on the card. You have to hover to se the days. And you cant actually use this info. Most people here want to have time in status in field and use it in formulas and pull it for reporting in other data analytics programs. Bottom line is that this feature should be native to the program. They have the information, they just don't want to make it easily available to us.

Boomer_V1

We are now just pulling everything into Google BigQuery using the BigQuery Connector for Jira and writing our own reports using Grafana. All the information you need for time in status is in the Issues and TimeInStatus tables.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration

time-tracking

report

status

time-in-status