time in status for non done issues

I would like to see how long an "issue" has been in its current status. It seems the gadget on my dashboards will only show items after they are marked done? Any way to config it show time in status for all issues related to the project.

Basically Today (or now)- last status change=> associated to current status?

8 answers


Detailed explanation of my points mentioned earlier.

1. Through Jira suite utilities: You can view the transition time per status per issue by installing the jira suite utilities plugin. Once installed, Go to the jira issue and at the bottom click on transitions summary and you will see the time the issue spent on each status. The only drawback is you do not get average time spent but the individual ticket time spent.

2. Jira charting plugin: This plugin has a chart - Average Time in Status. It displays the average number of days/hours issues have spent in a particular status.

2. Through Jira charts: Resolution time chart might be useful. It is a slightly different metric but you can use this metric the same way to manage performance.

'Resolution Time'— a bar chart showing the average resolution time (in days) of resolved issues.

  • This is useful to show you over time whether your team is getting better or worse at resolving issues in a timely fashion.

Hope it helps...



Time in Status plugin allows you track status duration with user, project and advanced mode. There is time span configuration. You can also export to excel.

Hope it helps,
Tansu Akdeniz

Is there any plug-in for on demand?


set @Status='Open;  -- change name to your status and project
set @Project='JRA';

select @Status,issuenum, sum(delta), count(*) loops from 
(select j.issuenum,startdate,min(enddate), TIMESTAMPDIFF(HOUR,startdate,min(enddate))  delta from
(select issueid, created startdate from changeitem i, changegroup g where g.id=i.groupid and field='status'
 and newstring=@Status) a ,
(select  issueid, created enddate from changeitem i, changegroup g 
  where g.id=i.groupid and field='status' and oldstring=@Status) b,
          jiraissue j where startdate<enddate 
           and a.issueid=j.id and b.issueid=j.id
           and j.project=(select id from project where pkey=@Project)
           and j.id=issue
 ) group by issuenum, startdate
) c group by  @Status, issuenum

if you need average, change sum to avg, or something like

Anyone: What is equivalent query in Oracle.

{code} define Status = 'Open' select &&Status, ... {code}

I don't see option to show average time in status for issues not resolved...is there a way to look at a current release (not complete) to see what was the average time spent in each stage...

We're looking for the same functionality. For example, we want chart the average time that issues CURRENTLY "in progress" have been in that status, and show the trend over time. Similar to JIRA's average age gadget, but for average time in a particular status.

This seems like fairly common metric many organizations would need, but surpringly I've been unable to find a plugin that does it.


we add the custom field and when we transition issue update the time diffrence to custom field this way we can work around it.

@tousif shaikh Could you please elaborate on how did you do that. I need that please. Thanks!

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

147 views 1 17
Join discussion

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