Track time spent in each status - Without Apps

[Søren Hansen]

Is it possible to se the time spent in each status in a given project - Only using the build in tools.  

I seems like that every time this question is posted the answer is always to "use this app"

[Emre Toptancı _OBSS_ · Accepted solution]

Hello @Søren Hansen ,

I am from OBSS and we are one of the vendors that built such an app, Timepiece - Time in Status for Jira.

Your options are limited without using an app (That is why we built the app in the first place).

If you have Jira Software, you can use the Control Chart that is part of Kanban Boards. The Control Chart doesn't show individual statuses, it shows board columns. If you configure your board to show a separate column for each status, you will get something useful. Even then, the chart will not show individual issues but will show clusters of issues. The flexibility and data are limited but it might be of help.

You can also go with Jira Automation. (I know that Automation is not available for all Jira editions). I won't go into details here. There are various other posts in this community that describes how to create a custom field and build some automation rules to calculate the time between transition dates. The downsides are: this is hard to build and maintain, you have to repeat this for each status time you want to track and it doesn't work for past issues.

You can also modify your workflows to calculate the times at relevant transitions and write them to custom fields. You probably will need some small workflow function apps for this one as well. The pain points are pretty much similar to those in Automation.

Actually, the raw data you need for calculating status times are available in the Jira DB (changegroup and changegroupitem tables). If you have the resources and the time, you can try calculating the times yourself.

When going through other posts, check the answers especially from @Bill Sheboy. He has some useful recommendations that might work for your need.

Hope this helps.

EmreT

[Mariana_Pryshliak_SaaSJet]

Hello @Søren Hansen 

As it's mentioned above, it's not possible to track the time spent in status without the add-ons. I recommend you to try Time between Statuses (server version) for such an aim.

All you need is to choose a necessary status as Start and Stop timers. And get the time spent in this status.

Also, you can export the report as CSV or XLSX files easily.

This add-on is developed by my SaaSJet team. Please, let me know if you have any questions.

Hope it helps

[Marta Woźniak-Semeniuk]

Hey @Søren Hansen It is not possible with JIRA without addons. 
However you can use a free addon for this -https://marketplace.atlassian.com/apps/1222051/status-time-free

I used this in my projects - gave us the info, is free and easy to set up :) 

We made a dashboard overview using this and it was awesome to easily see the info.