How to calculate a metic of days since last incident

[toddpreece]

I'm a bit of a Performance Analytics newbie so not sure how to do this. Does not seem to be a way to do this in the standard reporting.

We've been asked to provide a metric that shows the number of days since the last incident occurred (that meets a specific condition). For example, let's say over the last month we have 10 incidents due to human error and the most recent one of those was 2 days ago. In this case, we'd want a single score metric to display "2 days". Tomorrow comes (assuming no new incidents) and the score displays "3 days". Essentially the same as the old "days since a lost time injury" you see on construction sites.

Any help greatly appreciated.

[Adam Stout]

I would create an indicator to get the MAX created_on date.  Then create a formula indicator that takes

score_start - [[Last Created On]]

[toddpreece]

Getting close but apologize for the stupid questions as I get up to speed.

When you say indicator, I'm creating a new indicator, getting hung up on the indicator source. I'd assumed incident.closed but that only gets me tickets closed on today. how do I open up the range so that it includes any incident that matches my filter regardless of the date it was closed?

The formula indicator then references the other indicator I created?

Once created where do you view the output?

Thanks!

[ManosijSengupta]

Hi Todd

Did you get a solution to the above query?

[Bridgette Weiri]

I'd like to create something similar to this but I also was lost with @Adam Stout 's comment. Did you have any luck? 

Adam, is there an easier was to do this after a few years?