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 ?
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 .
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Now is available new Lite version of Time in status.
This add-on lets monitor each status duration data and exclude not-working hours from the calculation with multi-calendar.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Uğur,
You can use Status Time app. It generates status time report based on your working calendar.
If you are looking for a free app, you can try the free version, Status Time Free.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Emre Toptancı _OBSS_ ,
Thanks for your suggession . For now , i am looking for a free solution .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Let me know if this information helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Petter Gonçalves ,
Thanks for your response . Can we configure this "average time in status gadget" to take only business hours ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.