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 get summary of the total time a story/bug/task has been in a particular column

Gregory Carman

I'm looking for a way to get a summary or report that can show me how long an item (story/bug/task) has been sitting in a particular column. For example, an item gets moved from "In Progress" to "Ready for Testing". How can I tell (preferably in a report or query) how long that item has sat in the "Ready for Testing" column?

Accepted answers

Michael Yaroshefsky - Visor for Jira

Hey @Gregory Carman I think this might be possible using a custom field, or JQL.

But the easiest/cleanest solution might be to use the Time In Status plugin https://marketplace.atlassian.com/apps/1219732/time-in-status-for-jira-cloud?hosting=cloud&tab=overview

Not sure if you've already taken a look at that and it wasn't what you wanted? This older post might also help: https://community.atlassian.com/t5/Jira-Work-Management-Questions/Time-in-status-custom-fields/qaq-p/2721982

Hope that helps - if not reply and we can have a rethink!

All comments

Michael Yaroshefsky - Visor for Jira

Hey @Gregory Carman I think this might be possible using a custom field, or JQL.

Gregory Carman

I think this might be the solution, as I don't really enjoy writing custom JQL. I am going to run this past my squad to see what they think. Thank you Michael!

Michael Yaroshefsky - Visor for Jira

Happy to help and hope it works out for you.

You may also want to have a look around the marketplace for alternatives and weigh up pricing, Time In Status is the most well known for this though.

If that does (fully and genuinely of course) answer your question could you do me a favor and mark the answer as accepted? - No pressure

Danut M _StonikByte_

Hi @Gregory Carman,

You will most likely need a plugin for this, as Jira does not have a way to provide this information.

My advice is to search for an app on Atlassian Marketplace that is able to calculate time in a board column.

If you are willing to use a plugin, our Great Gadgets app can be the perfect solution. By using its Time in Status gadget you can easily calculate and display the time in status or time in board column (total or average) for the issues in a filter or board.

The gadget can display a Data tab where you can get the time in column or status for individual issues. The table can be exported in CSV format for further processing.

Danut.

Rahul_RVS

Hi @Gregory Carman

You can use Jira Rest API's to pull this data from issue changelogs. Or You can create your own custom fields and apply Jira automation to populate those. Another option could be to use Jira Control Chart which helps visualize the average data for one issue or a cluster of issues via dots on the chart Y.

Alternatively if you are open to try a mktplace app, pls do take a look at

Time in Status Reports

With this app you generate time in status and time with assignees reports with multiple filter and grouping options. With the ability to export to a csv file as well for further analysis as shown below. The reports can be added as a dashboard gadget too.

Also the app has many reports to meet a variety of time in status use cases.

More details here.

Disclaimer : I work for the vendor who built this app

Hannes Obweger - JXL for Jira

Hi @Gregory Carman

all status changes of an issue are captured in the issue's issue history (which is available via the issue view and the REST API), however you'd have to calculate the exact times in status yourself.

This is certainly cumbersome, and therefore an area where a lot of users rely on apps from the Atlassian Marketplace.

E.g., you may want to have a look at 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 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 XSLX (e.g., Excel or Google Sheets) or CSV in just two clicks.

Any questions just let me know,

Best,

Hannes

Vitalii_Bobak_SaaSJet

Hi @Gregory Carman

Jira has some built-in reporting capabilities you might find useful for tracking the time an issue spends in a particular status. You can use the Control Chart or the Average Age Report for some insights into cycle time and age, but they often lack the granular details that many teams need for precise analysis.

If you need more comprehensive reporting, Time in Status can be a great solution. Add-on allows you to see how long each issue has been in each status or column, providing detailed reports on time in status, cycle time, and other key metrics. This can be especially helpful if you want a breakdown for each issue or need to analyze patterns over time.

Additionally, Time in Status provides detailed breakdowns and visual reports (charts, dashboards, gadgets), which are helpful for tracking performance trends over time.

You can also book a live session or contact us at Support - we'll help you with Time in Status in Jira.

Add-on developed by my team.

I hope you find this helpful 🚀

Vitalii_Bobak_SaaSJet

Thank you so much, @Michael Yaroshefsky - Visor for Jira, for mentioning Time in Status! 🙌

If you or @Gregory Carman , or anyone else has questions about how Time in Status can fit specific needs or scenarios, feel free to reach out or explore more here.

Gizem Gökçe (OBSS)

Hello @Gregory Carman ,

Unfortunately, native Jira does not provide direct reporting on how long an issue has spent in a specific column or status.

So in order to track the time spent on each status & each assignee I suggest you use a marketplace app. Timepiece - Time in Status for Jira ,the oldest and leading "Time in Status" app in Atlassian Marketplace, which is developed by my team at OBSS, has several report types that will meet your need. Our app is available for both Jira Cloud, and Data Center.

Timepiece mainly allows you to see how much time each issue spent on each status or each assignee.

Status Duration report which shows how much time each issue spent on each status.

Status Duration in Days.png

Timepiece - Time in Status for Jira calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.
Let me know if you’d like assistance setting up a report in Timepiece or need additional guidance!If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Best regards,
Gizem

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