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; } } }

Create report for average time in a particular status

Cody Eberhardt

I am looking to create a report that shows the average time issues are in a particular status, in this case it would be the average time the issues are in the "Waiting for Support" status. I would like to do this without any add ons or plugins if possible.

Thank you!

Accepted answers

Mehmet A _Bloompeak_

There is no built-in solution in Jira. However, the data you need is available in Jira Rest API. It provides the exact status transition date and time for each issue. It returns json as below, but you need to extract and calculate for each issue.

We developed Status Time app for the exact need. It displays time spent on each status. You can export the data into excel and get the average time.

All comments

Mehmet A _Bloompeak_

Mariana_Pryshliak_Saasjet_qysy8m

Hello @Cody Eberhardt

Unfortunately, there are no built-in solutions but as an alternative, you can try Time in Status for Jira Cloud.

average time.png

Its' main function is to generate a report of how long issues have been staying in a particular status. BUT you also get Average Time report, which shows the average time issues have been staying in statuses during a specific period.

All reports are available as Grid and as Charts. and you can export data as XLSX or CSV file

I hope, this info will be helpful for you!

Best regards, Mariana

Mehmet A _Bloompeak_

Hi @Cody Eberhardt ,

We added average calculation functionality. You no longer need to extract and calculate the average on excel. You can see sample report on online demo here

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-desk