Time Since Last Breach (Streak)

[TSheward_SGW]

Hello Reporting Wizards,

Could anyone point me in the right direction for creating a widget I can throw up on a display to show how many days have passed since the team last breached their response SLA? 

Many thanks in advance!

Tom

[Guest]

Hi @TSheward_SGW

Really nice widget idea! I've had a go at building this and think I have the following working - would be good if you could give it a go and see if this tallys up with your stats:

 

Configuration (Widget Type - List of Counters):

 

In case you want to copy and paste:

SELECT: MIN
timestampdiff(DAY, h_fixby, now())
FROM: h_itsm_requests
WHERE: 
h_withinfix = 0
AND h_requesttype = 'Incident'
ORDER BY h_pk_reference desc
LIMIT 1

Obviously include which WHERE clause suits your measure - I've based mine on all Incidents. Also if you want to change this to look at the "Response" Target, use the following:

SELECT: MIN
timestampdiff(DAY, h_respondby, now())
FROM: h_itsm_requests
WHERE: 
h_withinresponse = 0
AND h_requesttype = 'Incident'
ORDER BY h_pk_reference desc
LIMIT 1

I hope this helps, let me know if there are any problems

Kind Regards

Bob