Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to assign Time In Status values to custom fields

ugur.gecgil November 12, 2019

Hi everyone , 

I am looking for ways to get time spent in spesific statuses  within Jira Software(Cloud).

For example  :

Time value spent in Open to  cf[xxxxx]
Time spent in In Progress to  cf[yyyyy]

I tried to enable Time in Status and [CHART] Time in Status fields but these fields does not takes value when i pull them from Google Sheets . I also can not get output from Time in Status Dashboard , all zero . 

Can you please suggest a solution ?

6 answers

1 accepted

1 vote
Answer accepted
ugur.gecgil April 5, 2020

i was able to solve this using jira rest api . 

1) retrieved the issue list 

2)got the changelogs for each issue 

3)calculated time spent in each status based on status changes in changelog . 

So dont need a field in jira anymore , running this script and writing result to my csv file .

viswa.reddy May 8, 2022

Hi Ugur,

 

This can be applied in Jira cloud as well? if yes, can you please provide the detailed steps please.

 

Regards

Viswa Mohan Reddy

0 votes
Zoryana Bohutska _SaaSJet_
Atlassian Partner
May 27, 2020

Hi 

Now is available new Lite version of Time in status.

a8633993-485b-4a23-a8a3-bc4dc3d8183f.png

This add-on lets monitor each status duration data and exclude not-working hours from the calculation with multi-calendar. 

Regards 

0 votes
Mehmet A _Bloompeak_
Atlassian Partner
April 5, 2020

Hi Uğur,
You can use Status Time app. It generates status time report based on your working calendar.
StatusDurations-M.jpg 

If you are looking for a free app, you can try the free version, Status Time Free.
IssueScreenView-3.gif   

0 votes
Julia Denys [SaaSJet]
Contributor
November 17, 2019

Hi @ugur.gecgil

You can use Time in Status for Jira Cloud, this add-on will show you the time in status report by default right after opening the application. Of course, you can customize then what kind of report you want to generate:

  • Assignee Time 
  • Average Time 
  • Status Entrance Date 
  • Time in Status per Date 
  • Status Count 

  • Transition Count

and filter the data by project, filter, report, label, sprint, and assignee (also by issue creation, update, and resolution date).

Moreover, you can view the report not only in a grid but also as charts (pie/bar/area) in the application and in the Issue View Panel.

You can extract reports in both excel and charts. Hope, this add-on will be a great solution for you.

0 votes
Emre Toptancı _OBSS_
Atlassian Partner
November 14, 2019

Hello @ugur.gecgil  ,

Our team at OBSS created Timepiece - Time in Status for Jira app for this exact need. It is available for Jira Cloud, Server and Data Center.

Using Time in Status you can report how much time each issue spent on each status, each assignee or even each user group. (useful for calculating lead/cycle times and identifying bottlenecks in your process). You can also see the number of times each status or transition was used (very useful for inspecting things like reopen counts). You can also list the status entry/exit dates.

You can get sums or averages of those times, grouped by any issue field(s) you like.

You can produce reports based on the default 24/7 calendar or define your own business calendars with custom workdays and working hours. 

All data can be exported as XLS, XLSX, CSV.

Emre Toptancı

OBSS

ugur.gecgil November 15, 2019

Hi @Emre Toptancı _OBSS_  , 

Thanks for your suggession .  For now , i am looking for a free solution .

0 votes
Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 14, 2019

Hello Ugur,

Welcome to Atlassian Community!

The default time in status field is created to configure the Average Time In Status gadget, which displays the average of time status for a bunch issues in a chart as described in the documentation below:

How to setup Average Time in Status Gadget 

Now, if you want JIRA to display the time spent for each issue status in a list format, I suggest you to try a third-party plugin to achieve your need, like Time Reports:

Screen Shot 2019-11-14 at 16.39.26.png

Let me know if this information helps.

ugur.gecgil November 15, 2019

Hi @Petter Gonçalves  , 
Thanks for your response . Can we configure this "average time in status gadget" to take only business hours ?

Suggest an answer

Log in or Sign up to answer