How to know the average time between statuses

[Deleted user]

Hi All, 

I am building a chart to show the average time it takes for an issue to go from "To Do" to "In Progress" status. 

I can't find the query to do that. 

Could you please help me to find this information?

Many thanks in advance. 

A.M.  

[Mehmet A _Bloompeak_]

Hi @[deleted] ,

Unfortunately, as far as I know it is not possible with query.

Issue history data is available via Jira Rest API. It provides the exact status transition date and time. It returns json as below, then you need to extract and calculate the date differences.

Or you can use Status Time app. It generates status time report/export. You can export the data and take the average.


If you are looking for a free add-on, you can try the free version, Status Time Free.

[Zoryana Bohutska _SaaSJet_]

Hi @[deleted] 

Also, you can try app Time Between Statuses.

It lets you get the information you need and export it for more details analyse.  Using external tools like Microsoft Excel or Google Spreadsheet, you can calculate the average time of exported data. 

Hope it helps

[John Funk]

Hi Ada,

You are probably going to need to use a third party tool like Nave. 

[John Funk]

There are some Chrome extensions that might help also.