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 ([Comment present]=TRUE AND [Comment public]=TRUE AND DATE_LAST_FIX([Update - Timestamp],[Comment present],[Comment public],[Updater name])=[Update - Timestamp]) THEN [Update - Timestamp] ENDIF
. Add the 'Comments' metric to the report builder. In the Filters panel, add the 'Ticket created - Date' attribute to show updates from the last week or month, and the 'Updater role' attribute to show Agents and Admins. In the Rows panel, add the 'Updater name' and 'Latest agent comment - timestamp' attributes, filtering out NULL values to see the latest comment timestamps by agent.
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: `IF…
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 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:…