We want to have an average time in status view - like a dedicated criteria / filter we want to be a

Question

Hi All,

in our Jira tickets we have a part called Transitions where i can see the time in Status, how can i use this information for reporting purposes?
Is there maybe already a report available where i can use this data?

We want to have an average time in status view -> like a dedicated criteria / filter we want to be able to have an average time in status from a dedicated committment point on.

How can i get those data, either exportable to excel so that we can calculate them or as average in Jira?

Kindly refer the attached image

Hannes Obweger - JXL for Jira · Answer

Hi @Thatiparthi Venkatesh

as you've surely noticed by now, this is an area where many Jira users rely on apps from the Atlassian Marketplace to fulfil their status time reporting needs.

If a Marketplace app is an option for you, I think you might like 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 - including all JSM-specific 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.

You may already know that you can trial any app for free for 1 month, so if an app is an option for you, perhaps try a few and see which one works best for you and your team!

Any questions just let me know,

Best,

Hannes

Valeriia_Havrylenko_SaaSJet · Answer

Hello @Thatiparthi Venkatesh 👋

I have an article for you Reporting capabilities in Jira Data Center.

Also you try out Time in Status add-on (Data Center version)

You can easily measure average time in status view with the Time in Status add-on. Simply select the Average Time report, apply relevant filters and get the ready report. This article helps you to get Average Time Report for Data Center version. Here you can read more about Average report in Time in Status.

What is the average time in state by filter?

This report shows the average time spent in a particular status in the chosen filter. You can filter your report by board, by week, open and unassigned etc.

What is the average time spent by project?

How long does it take on average for your team members to complete a project? Easily get the answer with Time in Status. You can select any dates for the time reporting period.

How to Export Average time in status data?

Click to Export data as XLSX or CSV. So you can analyze all these reports in detail by exporting data to Excel, Google Sheets and Power BI.

The add-on has a 30-day trial period and is free for small teams (up to 10 users).

See you! 👋

Amay Purohit_RVS · Answer

Hi @Thatiparthi Venkatesh

As an alternative, if you are open to try out a mktplace app to get this data, you can take a look at

Time in Status Reports

One of the many reports which the app provides is Time in Status in hours/days to determine , how much time the issue spent in each status in the complete lifecycle of the issue. You can group your statuses to define your own issue resolution time. The app has 20+ reports to track your bottleneck Issues & Processes.

The screenshot below shows the Avg Time in Status Report as per your use case.

More Details here

Disclaimer : I work for the vendor who built this app