I'm new to Explore and struggling to find the best approach to this.
I'd like to create a report to show % of tickets by Agent that were First Assigned within 2 hours of Ticket creation. One of my primary challenges seems to be being able to do the date compare between the two dates:
IF (DATE_FROM_TIMESTAMP([Ticket first assigned - Timestamp]) - DATE_FROM_TIMESTAMP([Ticket created - Timestamp])>21) THEN "Breach" ENDIF
Between creating custom attributes and custom metrics I continue to run into a dead-end. Any ideas on the best approach would also be helpful.
Please sign in to leave a comment.