Building Dashboards in Explore
I'm new to Explore and can't seem to display the metrics I need.
I am trying to simply show the length of time since the Customer who logged a ticket was sent an update on a ticket, so not first response time, just the last time they were updated (as some tickets go back and forth with customers).
I don't want the last activity on a ticket, as this would include internal comments, so in effect want to show the length of time since the last public reply was sent to the customer.
I can't seem to find a way to do this, is this possible? Thanks
-
Hi Hannah,
You can try building custom attributes and metrics for this. You may refer to this article about Working with earliest and latest date functions. There's a sample recipe in that article that shows how to get the latest public agent comment timestamp. From there, you can build your custom metric (using the DATE_DIFF function) to calculate how much time has passed since the event/timestamp. See Explore date functions.
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
1 Kommentare