To find the highest average resolution time per assignee, you can create a KPI that shows this metric across all assignees.
Create a new report in the Support - Tickets dataset and a calculated metric named 'Resolution time per assignee' with the formula:ATTRIBUTE_ADD(AVG(Full resolution time (days)), [Assignee ID])
. Use the MAX aggregator to find the highest average resolution time, and apply filters to show tickets solved in the last 30 days.
Aggregation-level functions in Zendesk Explore allow you to control how metrics are sliced by attributes in your reports. Normally, metrics are sliced by all attributes added to a report, but with aggregation-level functions, you can specify which…
The ATTRIBUTE_FIX function in Zendesk Explore slices a metric by only the attributes specified in the function. This means that any other attributes added to the report will not affect the metric, although filters will still apply. This function is…
The ATTRIBUTE_ADD function in Zendesk Explore extends the metric aggregation to include additional attributes specified in the function, along with those already in the report. This means that the metric will be sliced by both the report's…
To find the total number of tickets per group using ATTRIBUTE_FIX, you need to create a calculated metric that returns the total number of tickets in each group without being sliced by other attributes. Start by creating a new report in the Support…
To calculate the percentage of tickets from the quarterly volume, you can create a report that shows the percentage of tickets created each month from the total number of tickets created each quarter. Create a new report in the Support - Tickets…
To compare the yearly and overall full resolution time, you can create a chart that shows the average full resolution time for each year and compares it to the overall average resolution time. Start by creating a new report in the Support - Tickets…
To find the average number of tickets per group using ATTRIBUTE_ADD, you can create a calculated metric that returns the average number of tickets per group without adding the group attribute to the report. Create a new report in the Support -…
To find the average number of ticket comments per agent, you can create a bar chart that shows this metric. Create a new report in the Support - Tickets dataset and a calculated metric named 'Comments per ticket' with the formula:…