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…
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:…
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:…