How can i export Time in status in Transitions?

[Leticia Kralik]

Hi!

I'm brazilian and we use Jira in our company. I would like to know how can i export the information on time in status.

In the image below i show how we see this information now, by issue.

[Mehmet A _Bloompeak_]

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.
   

[Emre Toptancı _OBSS_]

Hello @Leticia Kralik ,

If you are looking for a ready solution, our team at OBSS created Timepiece - Time in Status for Jira app for this 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. You can get sums or averages of those times across issues, grouped by (or broken down by) any issue field(s) you like. (Consolidating status column values to calculate cycle time directly is in the works, will be available soon.)

In addition, 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 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

[Julia Denys [SaaSJet]]

Hi Leticia, welcome to Atlassian!

You might look at Time in Status for Jira Cloud. With this add-on, you can generate and later export Time in Status report as well as 6 other reports: Assignee Time, Average Time, Status Entrance Date, Time in Status per Date, Status Count and Transition Count.

In this add-on, you can filter the data by Assignee, Filter, Label, Project, Reporter or Sprint.

To export the information on time in status in the add-on, you just need to click on the export button in the top right corner and choose a file format.

Also, you'll be able to get Time in Status report right after opening the add-on. 

You can view your report not only as a table but also as charts (Pie/Bar/Area chart which you can also export).

Hope this is helpful