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?
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.
Hope it helps...
-- TIME IN STATUS - MySQL VERSION 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
Thanks...! Your query is great ...! Please, could you tell me the correct way to write the sentence below:
"... where startdate < enddate ..."
I don't know what's it "<". I think that is an operational sign, but which is that?
thanks a lot.
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.
It would be ideal for us to be able to see the time in status on our board, so during standup we can at a glance see if stories are taking a long time in progress or blocked, etc. With a lot of team members, there is a lot in progress and hard to keep track of which ones might be stalled and which are just new tickets
In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to have–in order to produce a reliable long-term roadmap. We're tur...
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!
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