How to export "Time in Status" data for custom statuses in Jira?
6 answers
Hi @kkostic
Welcome to the community !!
You can achieve this by using Jira Rest API's -> https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/
The other option is to use a mktplace app. If you would like to try out one, I can suggest the our app :
You can generate reports such as:
- time in status for Jira issues
- how long colleagues have been assigned to issues
- average time issue has been spent in each state
- date of issue entry into a status
- transition and status count for each issue
- Group your statuses to define your own Cycle/Lead times
- Export your data to a BI tool like Power BI or a csv file
Disclaimer : I am part of the app team for this add-on
Hey @kkostic ,
That's a great question, and it's one of the most common and frustrating reporting challenges in Jira.
To answer your question:
Native Dashboards have a "Time in Status" gadgets, but they show averages for all issues. They don't provide the "per-issue" breakdown you're looking for in an exportable list.
Crucially, Jira's built-in 'Time in Status' gadget can be misleading because it doesn't support custom calendars. This often results in inaccurate data.
Because of these native limitations, a dedicated Marketplace app is almost always the best solution.
Timepiece - Time in Status for Jira’s main Status Duration report instantly generates the exact table you're asking for. It shows all your issues in rows and all your statuses (including your custom ones) in columns, with the precise time spent in each.
The key benefits are:
It's Retroactive: The moment you install it, it can run a report on all your past and existing issues because it uses Jira's built-in issue history.
It's Accurate: You can use custom calendars to exclude non-working hours (nights, weekends) from the calculation.
It's Exportable: You can export this entire per-issue report to CSV or Excel for your reporting needs.
It's Automated: With the 'Scheduled Reports & Alarms' feature, you can fully automate your reporting. Just set your preferences, and Timepiece will send reports to your inbox, MS Teams, and Slack channels as often as you'd like.
You can check it out on the Atlassian Marketplace. Hope this helps you get the data you need!
Full disclosure, I'm on the team that makes Timepiece - Time in Status for Jira.
Hi @kkostic ,
I see that the Community Champion @Valerie Knapp has already recommended our Time in Status app by SaaSJet (I am part of this team).
It is quite challenging to meet your needs without a third-party app. I would just like to add that our app's capabilities include file export (CSV, XLS), as well as dynamic export using JSON Data Feed Link — with its help, you can download data that will be updated in Power BI, Google Sheets, Confluence, and other analytical tools.
Also, as part of the app's functionality, we have custom fields that calculate time in status, and you can see their values on the issue card on your board. You can then use them by exporting data via the Jira API, in JQL search, and when creating simple automations.
I hope this will be useful to you.
Hi @kkostic,
Welcome to the Atlassian Community.
I'm afraid it's not possible to export this information with the built-in Jira tools. You'll need a 3rd party app (plugin).
If you decide to try an app from the Atlassian Marketplace, this can be easily done using the Time in Status gadget offered by our Great Gadgets app, which can display the issues from a board/filter/JQL with their time in each status on its Data tab. You can click the Export button to exported the data 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.