Dashboard magic needed: Time between resolution dates of tickets in a filter

Question

Hello All,

for a KPI that we want to implement (loosely based on https://www.producttalk.org/2020/06/measure-discovery/ ) I would like to get a number that indicates that average time (in days or hours) between ticket resolutions of a subset of tickets in a project.

Thus if there are 3 tickets in a filter and the resolution time of the respective tickets are T1,T2,T3 I would like to get the number  ((T3-T2)+(T2-T1))/2 either as a moving graph or just as a single number. Working with the current time is also fine if that would exist (which would lead to the formula ((now()-T3)+(T3-T2)+(T2-T1))/3

Does anyone know how to achieve this ?

Best regards,

Ron

Tuncay Senturk _Snapbytes_ · Answer

I see @Ron Geens

I'm afraid, you have to write some script to achieve that.

Ron Geens · Answer

Hi Tuncay,

thank you for your answer but the presented solutions are all related to times/fields in the same ticket while I am actually looking for difference in time between tickets.

I can indeed do an export of the fields I need (ticketID and resolutiontime) and then use excel to do the processing but it would of course be more interesting to do this automatically in Jira.

Best regards,

Ron

Tuncay Senturk _Snapbytes_ · Answer

Hi @Ron Geens

Welcome to the community.

You have to use an app for such a field/gadget.

One option (as I am one of the folks behind Snapbytes) is Enhancer Plugin for Jira.

* Time Between custom field makes it simple to get that value. You can search against this field and export to excel so that you can make any operation, calculation.
* Time between gadget presents the time between value (either in hours or days or both, ..) in your dashboard
* Averaged time between gadget presents the average time

Also, there are lots of valuable KPI metrics in this app. You can try free and let us know whether you need further assistance.

Kind regards

Tuncay