I am trying to make decisions on class of service from the board or issue view before digging in to the control chart.
So far, I have added a custom 'Time in Status' field called 'StatusDuration' and administered it to display in 2 projects. I believe this is different than the '[CHART] Time in Status' that is referenced in time-in-status.
However, no StatusDuration is visible as part of the issues that I'm looking at. I have enabled the JIRA Charting Plugin mentioned in the thread above which shows "time in source status" as part of a new tab called transitions, but that only aggregates the history and doesn't show how long it's been in the current status.
Even if it's not available in JQL (which would be even better), I understood it to be available as it lets me associate it with screens:
Hello, the "Time in Status" or "[CHART] Time in Status" fields are not editable and therefore will not appear on issue screens. The field just needs to be assigned to the appropriate issue screen(s) and are intended to provide data to the "Average Time in Status" gadget. We've checked this on a test instance and we have been able to get the "Average Time in Status" gadget working . We used "[CHART] Time in Status" in our tests. For more information on the gadget, please see - How to use Average Time in Status gadget. Custom Field type 'Time in Status' is only useful when used together with the JIRA charting plugin.
No, there is an issue here. The issue is that even if the person who was trying to use this field "incorrectly", the fact that WHAT they were trying to accomplish:
As someone who's paid a significant amount of money for Jira
I want to capture "INDIVIDUALLY" what the linger time of an item in a particular state in the currently applied workflow.
So that I can download that data and do WHATEVER I FEEL LIKE with it reporting-wise.
This is what 99.9% of folks out there are likely thinking about, and yet Atlassian refuses to acknowledge that NOT ALLOWING those values to be exported that it is being ANTI-USER.
You statement is equivalent to saying "The Customer who's paying me for a service, is incorrect in asking for X". That is very flippant of someone who represents Atlassian.
Time/Days in Status is a very common request so I spent a little time ironing out a reasonably simple solution. 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.
@Jonathon S - this was so easy to follow and worked like a charm!! thank you so so much for putting this together. The only thing that could have made this easier would have been if you including instructions on how to find the customfield id (or a link to a site/thread with instructions) - other than that, this was great and I think will be very useful for the people on this thread.
Hey Jonathan - I'm wondering if you have any advice for where I may have botched the setup here, as I'm not seeing the correct days in status on my cards or in my search. It either shows me an issue has been in the status for "1" day or for "18,211" days- and neither are correct haha.
Any ideas on where I could/should troubleshoot this?
I'm having the same issue in my instance of JIRA Cloud.
Is anyone from JIRA reading these requests? Hope someone can help. Time in Status is of critical importance to our management strategy.
I believe there are no built-in solutions for this but we ported our Time in Status app to Jira cloud platform.
Time in Status app can report how much time each issue spent on each status, on each assignee, on each group. The app can also report on status and transition use counts.
The app can even calculate averages grouped by issue fields you select.
You can export report data as CSV, XLS or XLSX.
You should give it a try.
You can reach us via firstname.lastname@example.org if you have any questions.
There are no built-in solutions for cloud version now.
But this problem can be solved by using an app from Atlassian Marketplace, like Time in status for Jira Cloud by SaaSJet created by my team.
Try its free trial version and appreciate all of its benefits for your project management process.
Can I use Time in Status with JQL filters to show the average amount of time a group of issues spent in a given status?
For example, based on a filter of 100 issues, what was the average time those issues were 'in progress'? Additionally, are there any ways I could visualize this data such as in a Jira Gadget?
Thanks and please let me know,
With all due respect, your plugin does not resolve this issue in the Cloud version. Having tried it, it does not cleanly report (nor allow for export) the data from a project's workflow of the Cycle Time (which in effect "Time in Status" is) for each activity state.
Sadly, my trial has expired, and I can't go back and scrounge around for this.
While my trial was active, I did correspond with someone from your company about this, and had left the door open where I would take time from my schedule to walk them through where my concerns lay....I received no response desiring clarification on my part.
Yes you can use Time in Status by OBSS to get average durations for issues in a JQL filter. Both server and cloud versions support this.
Considering the fact that average calculation has to go through not all issues but also all issue histories, it can be expensive for your Jira instance if you have a large number of issues. Currently, due to performance considerations, average calculations are intentionally made available only through file exports and REST API. We are working on possible optimizations for average calculations and plan to make this available through Jira UI in future versions.
We are glad to get in contact with you here. Our support team tried to reach you at the beginning of May but could not get a response.
As we said in our response, both Server and Cloud versions of Time in Status allow export of report data in XLS, XLSX and CSV format. The export button is on the far right of the toolbar on the report screen.
We technically can't give you another trial for cloud but we will be happy to extend your trial if you have a Jira Server. You can also see the live demo by going to plugindemo.obss.com.tr
For any questions or feedback, you can reach our support team by sending an e-mail to email@example.com .
@Marcelo Lopez It looks like you wrote about another plugin. Our application is "Time in status for Jira Cloud" by SaaSJet.
We discussed the export and time format with you. You have sent us a few interesting ideas.
Contact us via firstname.lastname@example.org if your trial period have expired, and we will provide you possibility to continue using the app so you can appreciate all of its benefits:
- Functional for 7 types of reports generation: Time in Status, Assignee Time, Average Time, Status Entrance Date, Time in Status per Date, Status Count and Transition Count.
- Possibility wiev data as tables and as charts
- Data export
Now you can get the average time in status using our app Time in status for Jira Cloud by SaaSjet.
In the updated version of this add-on you can measure your team delivery with new kinds of reports and also view them as charts (Pie, Bar and Area Charts).
You can try all of the above and much more with the free trial.
Let me know if this is helpful.
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
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