Resolution time query on jira

[Graeme Park]

The resolution time gadget shows the number of days between creation and resolution date. I want to be able to show this in hours or minutes - is there a way to do this using generic addons?

[Piotr Bojko]

You can do this with the help of Smart QL app

With smartql create a view with query 

select FLOOR(resolved TO DAY) resolution, avg(TIMESTAMPDIFF(minute, created, resolved)) td 
from core.issues
where resolved between ? and ?
group by FLOOR(resolved TO DAY)

Then plan the SmartQL Chart Gadget on a dashboard.

Configure as follows (change the dates for your needs :) )

Then you will have:

[Graeme Park]

should have said this is for cloud.

[Piotr Bojko]

Ouch, sorry :/

[Aleksandr Zuevich]

Hi Graeme,

There is Hourly Period option:

[Graeme Park]

Thanks, but that shows the data per hour time slot, not the resolution time in minutes. E.g. with that one I just get 2days as the answer as opposed to 37hrs but shown every hour.