Hi, I'm trying to find the Time a ticket spent during Business Hours in a particular field before moving out.
This is the metric I'm using to get my tickets.
IF ( [Changes - Field name] = "Current Escalation" AND [Changes - New value] = "X" AND [Changes - Previous value] = "Y" )
THEN [Ticket ID]
ELSE NULL ENDIF
Now I need a report where I will know how many hours each ticket spent in business hours and outside of business hours before the field changed from X to something else.
I tried using the following logic to create an Attribute but not working for my ask.
Let me know if there is a solution to this.
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.