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 attributes and the ones you add.
This function is useful for calculating averages or medians based on attributes not present in the report. For instance, you can use ATTRIBUTE_ADD to find the average number of tickets per group without displaying the group attribute in the report.
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…
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 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…
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:…