CountDistinct Response Time in Seconds
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 ticket ID.
I tried working with some things on the other posts but I think using this Case Count Distinct it is counting the distinct times as opposed to the IDs? I had two different calculations one with the less than equal then another with greater than,
I hope I have given enough info to understand what I am trying to get, I have my month by month graph using Created At and YOY but I cannot get the bar to match the total number of incidents, because I am almost certainly doing that wrong