It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Display 'Time in Status'

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: 

StatusDuration.png

 

8 answers

1 accepted

2 votes
Answer accepted

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.

 

Really disappointing that the response to this issue is to remove the option, not actually make it work. 

There's no issue here, just a misunderstanding of what the field does.

Hi Nic, 

so is there a way to add a custom field "Time in status" to issue view screen?

Is it possible to do it using Adaptavist ScriptRunner?

Nic,

 

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.

Like # people like this

I totally agree with Marcelo -- this is just sad that we cant collect the data appropriately -- I need to understand at the issue level - NOT the average -- average gives you false information - UGH

Like # people like this

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.  

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

@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.   

 

Thank you!! 

thanks for the feedback!  I went in and made sure the link to the customfield ID instructions are much more visible :)

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.

  • Installed "Time in Status" field
  • Added field to all the screens where I'd like it to appear
  • No joy

I've tried:

  •  un/reinstalling
  • deleting the (CHART)Time in Status field that was reported to conflict with this field
  • RTFMing for a good four hours

Is anyone from JIRA reading these requests? Hope someone can help. Time in Status is of critical importance to our management strategy. 

No, apparently no on inside Atlassian is reading any of this...but that shouldn't stop us documenting the issues.

Like # people like this

Ugh, I thought I was doing something wrong. PLEASE HELP!

A related issue. In our Jira cloud we no longer have the checkbox "Days in Column". Has this functionality been removed? 

Yes apparently that's been removed.

Hi there

Are there built-in solutions for cloud version now?

Hello Joseph,

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.

https://marketplace.atlassian.com/apps/1211756/time-in-status?hosting=cloud&tab=overview

You can reach us via plugin@obss.com.tr if you have any questions.

Best regards,

@Joseph Patin 

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.

Best regards,
Mark 
SaaSJet

@Emre Toptancı -OBSS- 

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,

Sam 

Mark,

 

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. 

@Sam Ferguson ,

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.

EmreT

@Marcelo Lopez ,

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 plugin@obss.com.tr .

Best regards,

EmreT

@Sam Ferguson  we are planning to develop our add-on "Time in status for Jira Cloud" by SaaSJet. And your case is interesting for us.

Please contact us by support@saasjet.com or write your e-mail adress here.

I will be waiting for your letter!

Sincerely
Mark
SaaSJet

@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 support@saasjet.com 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 

Regards
Mark
SaaSJet

Hi @Sam Ferguson 

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Core

How to manage many similar workflows?

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 ...

1,321 views 8 2
Join discussion

Community Events

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

Events near you