Average Time in Status

[Newelle Horn]

Need to find out the average time between a request being submitted and the steps in the process of completing them.  

Is there any way to do this?

[Kurt Klinner · Accepted solution]

@Newelle Horn 

https://confluence.atlassian.com/jirakb/how-to-use-average-time-in-status-gadget-776998092.html might be worth a look as well as that there are commercial plugins available on the marketplace like https://marketplace.atlassian.com/apps/1211756/time-in-status?hosting=cloud&tab=overview

Cheers

Kurt

[Newelle Horn]

I don't have the rights to upload anything on the Jira tool so is the the only option for getting average times?  

[Kurt Klinner]

@Newelle Horn 

if you have access to the database you could use the queries shared within

https://community.atlassian.com/t5/Jira-questions/Get-quot-time-in-source-status-quot-value-using-SQL/qaq-p/171166

https://community.atlassian.com/t5/Jira-questions/Get-quot-time-in-source-status-quot-value-using-SQL/qaq-p/171166

Cheers

Kurt

[Newelle Horn]

Thanks, Kurt - these are VERY helpful - appreciate it!  

[Kurt Klinner]

@Newelle Horn 

Glad to hear that.  If you think the answer is helpful, feel free to accept it so that other community members are aware of a possible solution

[Tuncay Senturk]

Hi @Mariana Pryshlyak 

According to Atlassian Community guidelines you should not 

No necroposting: Aka, no "raising threads from the dead." In general, avoid posting on old threads (six months or more old) simply to promote your products.

Tuncay