4 answers
Hello @Jairo Monteiro ,
You can build a custom solution using the Jira REST APIs, but it can become a lengthy and time-consuming project. You’d need to pull issue changelogs and parse them to extract the data you need, which can be complex and error-prone. If you prefer a faster and more reliable option, you might consider trying a Marketplace app built for this purpose.
Timepiece - Time in Status for Jira has a 'First Transition To Status Date' report, exactly what you are looking for.
With Timepiece:
You’ll get a list of all issues within your chosen date range,
The selected statuses will appear as columns,
And you’ll see the exact first transition date and time for each status. This way, Timepiece provides the complete report you need; there is no need to work with the API or changelog.
You can configure the report with one-click using custom JQL you already have, or use Timepiece’s Rovo-powered Assistant, and it can generate a report for you.
Once the report is ready, you can export it to Excel or CSV for easy sharing or further analysis. Moreover, you can directly create reports for past and ongoing issues, just after installation.
You can find Timepiece - Time in Status for Jira on the Atlassian Marketplace. Hope this helps.
Full disclosure, I'm on the team that makes Timepiece - Time in Status for Jira.
Best,
Birkan
Hi @Jairo Monteiro,
You could use the endpoints of the Jira Cloud REST API to retrieve issue changelogs, then parse them to extract the required information. However, this approach is complex and prone to errors.
My recommended approach would be to search for an app (plugin) on Atlassian Marketplace that is capable to generate this as a report.
If you are willing to try an app, our Great Gadgets app offers some gadgets capable do generate such a report.
Here is how you can do this:
- Add the Control Chart gadget to your Jira dashboard
- Configure it with a filter / JQL that returns all issues created between 01/01/2026 and 01/31/2026 and custom time interval 01/01/2026 to 01/31/2026
- Configure "Cycle starts" = status In Progress and "Cycle ends" = status "Done"
- At Multiple cycles choose Display as one cycle.
- Check the option to display the Data tab (on its More Setting tab)
As a result, it will display a chart will also the issues that had such cycle during the time interval.
On its Data tab you will find the report you need. You can then export it in CSV format.
Hope this helps. If you need any help, feel free to contact support@stonikbyte.com for assistance.
Danut
You can write your own custom solution using Jira Rest API's. However this could be a lengthy and time taking project. Or if you would like to explore a mktplace app for this requirement, you can try out
With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options.
With Status grouping feature, can help you define your own issue age time and view the averages of the same. Also the app has 20+ reports to meet a variety of use cases.
Also the app has a custom calendar option to define your working hours and days which will be taken in calculation for time in status.
I have added the screen grab of Status Transition details reports, where in it shows the date and timestamp of the status transition.
Disclaimer : I am part of the app team for this add-on
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.