How to Display History of Jira Item Statuses

[MIke Killion]

I spent more time than I should have trying to find an answer for this and kept coming up empty. 

My team needs to be able to track the dates that a Jira item's statuses changed. Ideally this would be in a table where the Jira item is the row, each column is the different statuses of that item, and the cells would be the date that the Jira item changed to that status.Most importantly, I want them all to autopopulate. We're really trying to reduce the amount of administrative work and errors. Something like the below. 

My organization does not allow us to install apps.

[Hannes Obweger - JXL for Jira]

Hi @MIke Killion

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, I believe that your requirements would be perfectly met by 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 long list of so-called history columns that aren't natively available, including the time in [status], time between [status] and [status], and many, many more.

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.

Of course, you can also export your data to Excel or CSV in just two clicks.

Any questions just let me know,

Best,

Hannes

[Ayça Erdem_OBSS_]

Hello @MIke Killion 

Welcome to the community 

The data you need is stored in Jira's issue history, but Jira doesn’t provide a built-in way to extract it into a structured report automatically. Manually digging through issue histories is time-consuming and errors.

That's where Timepiece - Time in Status for Jira, developed by my team at OBSS, comes in. Our app includes a Last Transition to Status Date report that provides exactly what you're looking for.

How It Works:

Automatically extracts the last date an issue transitioned into each status—no need to check issue histories manually.

Displays data in an easy-to-read table format—rows for issues, columns for statuses, and cells for transition dates.
Always up-to-date—eliminates manual tracking and reduces admin work.
Available for both Jira Cloud and Data Center.

Jira doesn’t offer a direct way to generate this type of report, but Timepiece - Time in Status for Jira makes it effortless.

You can explore Timepiece - Time in Status for Jira on the Atlassian Marketplace and start a free trial to experience all the features.

Hope this helps! Let me know if you need more details.

Ayça

[Valeriia_Havrylenko_SaaSJet]

Hi @MIke Killion  👋

Welcome to the Atlassian community!

If an app from the Atlassian Marketplace is an option for you, try Time In Status. To track the dates that a Jira item's statuses changed just simply:

1. Choose the Status Entrance Date Report
2. Filter issues by created, updated, resolved and apply date and time ranges 
3. Enjoy your report in table, chart or dashboard view  🥳
   
   

Table view:

Also you can visualise data with chart view option :

Add-on developed by my team.

I hope you find this helpful 🚀

[Rahul_RVS]

Hi @MIke Killion 

Welcome to the community !!

If you would be interested in a mktplace app for this requirement, you can try out

Time in Status Reports 

With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options. You can also extract trends analysis and add that as a dashboard gadget too. 

The app shows Status Transition dates for your specific requirement as shown below. Do try it out.

More details here.

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

[Mathew Lederman]

Unfortunately this data is not easily captured out of the box. There are 2 primary options from my experience:

1. Create an automation rule and however many custom fields as you have statuses. When an issue transitions to each status, you populate the associated custom field with the current datetime stamp.
   1. Many teams also want to know time in status, so another custom field to capture how long an issue was in 'To Do' before it moved to open could be part of the same automation rule.
2. Many add-ons track time in status. The data you're looking for should be available from these add-ons.

[MIke Killion]

Thank you much! I'll give that a try! 

Unfortunately my organization does not allow us to use apps