To find the earliest daily ticket assignment, use the DATE_FIRST function in Zendesk Explore.
Start by creating a report with the Support: Tickets dataset. Create a calculated attribute named 'Earliest assignment - timestamp' using the formula:IF DATE_FIRST([Ticket first assigned - Timestamp])=[Ticket first assigned - Timestamp] THEN [Ticket first assigned - Timestamp] ENDIF
. Add the 'Tickets' metric to the report builder. In the Rows panel, include 'Assignee name' and 'Ticket assigned - Date' attributes, and configure the date attribute to show tickets created this week. Finally, add the 'Earliest assignment - timestamp' attribute and filter out NULL values to see the earliest daily ticket assignments by assignee and date.
Zendesk Explore offers functions to find the first or last event in a series. These functions help you focus on unique events, like the first or last update of a ticket. The four main functions are: -DATE_FIRST(time attribute):Returns the…
You can use the DATE_LAST function to identify tickets solved on the last day of the month for each group. To create this report, start by using the Support: Tickets dataset. Create a calculated metric named 'Tickets solved on last date' with the…
The DATELASTFIX function helps you find the final resolution date of tickets that may have been resolved and reopened multiple times. To create this report, use the Support: Updates history dataset. Create a calculated metric named 'Final…
To find the latest agent comment time, use the DATELASTFIX function in Zendesk Explore. Create a report with the Support: Updates history dataset. Create a calculated attribute named 'Latest agent comment - timestamp' with the formula: `IF…
To calculate the first internal comment time, use the DATEFIRSTFIX function in Zendesk Explore. Create a report with the Support: Updates history dataset. Create a calculated attribute named 'First internal comment - Timestamp' with the formula:…