7 answers
Hello @Mar Angelo L_ Tareno ,
There is no built in solution in Jira for this. So in order to track the time spent on each status I suggest you use a marketplace app. Timepiece - Time in Status for Jira ,the oldest and the most comprehensive "Time in Status" app in Atlassian Marketplace, which is developed by my team at OBSS, has a report type that will meet your need. Our app is available for both Jira Cloud, and Data Center.
Timepiece mainly allows you to see how much time each issue spent on each status.
Status Duration report (please see the screenshot above) which shows how much time each issue spent on each status.
The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.
Timepiece reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs.
If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.
Hope it helps,
Gizem
Hi @Mar Angelo L_ Tareno 👋
Іf you consider installing third-party add-ons to help, you can try Time in Status that helps to get the count days per Status. For this just:
- Choose Time in Status report and sort by project (assignee, sprint, any JQL etc)
- Filter Issues by preferred time
- Get your report!
You can also book a live demo - we'll show you the application inside out and answer all your questions.
Add-on developed by my team.
Have a nice day 🥳
You can use Jira Automation to populate a custom field on status time every day. or you can also use Jira Rest API's to pull this data from issue change history.
Another option could be to use a mktplace app. If you would be interested in the same, you can try out our app
The below report will suffice the requirement. Also with this app you generate time in status for multiple issues with multiple filter and grouping options. You can also group your statuses to define your resolution times. The app can easily be added as a dashboard gadget.
Disclaimer : I work for the vendor who built this app
We developed Status Time Reports app for this exact need. It is free up to 10 users.
If you are looking for a completely free solution, you can try the limited version Status Time Free.
If you have any questions, feel free to schedule a free call with us.
As you can see from the previous answers, this is an area where many Jira users rely on apps from the Atlassian Marketplace to fulfil their reporting needs.
If a Marketplace app is an option for you, I think you'll like the app that my team and I are working on, JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called history columns that aren’t natively available, including an issue's time in [status].
This is how it looks in action:
As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. You can also configure the cell format of your columns, if you prefer to see the number of days for a particular status.
Of course, you can also export your data to XSLX (Excel, Google Sheets) or CSV in just two clicks.
Any questions just let me know,
Best,
Hannes
The report you need need looks like a time-in-status report. As far as I know Jira does not have such chart or report. You could search on Atlassian Marketplace for an app that provides a time-in-status chart or report.
If you are open to the idea of using an app, our Great Gadgets app has a Time in Status gadget that offers this info as chart (pie, bar or column) or table.
It can be configured to calculate in days, hours or minutes.
On its Data tab, you can see details at the issue level. This report can be exported in CSV.
Danut.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.