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?
Hi Graeme,
There is Hourly Period option:
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.
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.issueswhere 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:
should have said this is for cloud.
Ouch, sorry
It looks like you're new here. Sign in or register to get started.
