nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to export "Time in Status" data for custom statuses in Jira?

kkostic

Hi everyone,

I’m trying to export Time in Status data from Jira Cloud, including custom statuses used in our workflows. I need this data for reporting purposes — ideally per issue, showing how long each one spent in each status.

Is there a way to do this without using any third-party apps (e.g. directly from Jira, via JQL, dashboards, or automation)?

Any suggestions or workarounds would be greatly appreciated.

Thanks in advance!

Accepted answers

All comments

Valerie Knapp_gp7rpj

Hi @kkostic , welcome to the Atlassian Community and thanks for your post.

Do you mean that you are using the app / plugin 'Time in Status'? If so, they already have some reports - https://help.saasjet.com/tis/reports-of-time-in-status

Are you not able to customise those to get what you want?

If you cannot find what you need in the documentation, please reach out to the vendor, who should be able to help - https://marketplace.atlassian.com/apps/1219732/time-in-status?hosting=cloud&tab=support

Or do you mean that you have some other way of measuring the time in status that you want to export?

Best wishes

Marc -Devoteam-

Hi @kkostic

Welcome to the community.

This could be done by doing API calls per issue and then extract the inforamtion from the response for each issuer. This is time consuming

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-issueidorkey-changelog-get

You can't do this it ootb Jira or JQL

3rd party integrations can help, like time in Status or Dashboard Hub Pro

Birkan Yildiz _OBSS_

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.

Screenshot 2025-11-11 160416.png

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.

Rahul_RVS

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 our app :

Time in Status Reports

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

More details here.

Disclaimer : I am part of the app team for this add-on

Danut M _StonikByte_

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.

Iryna Komarnitska_SaaSJet_

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.

Petru Simion [Simitech Ltd.]

Hi @kkostic ,

If you are open to using apps you can export using Time in Status Dashboard for Jira , one of the apps released by our company.

You can either search for all result by project or filter using the available fields and Export as CSV.

You can chose between the two perspective.

Columns Perspective

Rows Perspective

Regards,

Petru

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud