Need Average Time in Status (Plugin) Query to export to Excel

[INFR TEAM]

Hi Everyone,

I added the Time in status Plugin to my Jira dashboard, and i really need to export the results to excel for reporting purposes.

I tried ading Time in statues field to my filter, but it just does not appear on the report.

Basically i need to know how much time did tickets stay in X status ?

Does anyone know how to do the JQL query in order to get this information? Is there any other way of getting this information?

Thanks a lot!

[ryanmoorman]

Still haven't found a solution for OnDemand products. Nearest thing is getting a script to update the field, but I can't get the plugin for OnDemand.

Our SM really wants to be able to do his own burndowns and view it by issue.

I would love to hear from Atlassian on this...

[Chris Kent]

I would love to know the answer to this as well, we are looking for the total sum of duration for a particular state of all resolved issues...

Does anyone know? Atlassian....