-
BM Calculation Aged Incidents
Hi I am trying to calculate which of my incidents are Aged (over 30 days old from the current date), I have cobbled this together but it can't be working as I change the number and get the same result CASE WHEN DATEDIFF( CURDATE(),Max(`created_at`)) > 30 THEN 'Aged' ELSE 'Not Aged' end Could somebody help please? Kind…
-
Connector & DataSet Issue
Hi I am using an out of the box Connector for my ticket data but the only two options are Append and Replace, I firstly pulled down 365 days and now each day I either have the option to do an append or replace, if I replace I lose 365 days data and left with 24 hours so I use Append (API limits mean I couldn't do a total…
-
CountDistinct Response Time in Seconds
Hi I am trying to produce a graph by month for tickets which have met my Response SLA. I have a Countdistinct already on ID as there are duplicates annoyingly but I have a field Response time in seconds and I want to work out which tickets have <=900 and which have >900. Response Time in Seconds is my field and ID is my…
