With this recipe, you will be able to highlight an agent against the rest of the team. The article calculates performance based on assigned tickets but you can apply it to any other KPIs.
What you'll need
Skill level: Average
Time required: 20 minutes
Data source: Tickets
Ingredients:
- Two standard calculated metrics
- A third standard calculated metric to enhance your report (optional)
How to create the report in Explore
To compare an agent's tickets against the rest of a group, create two standard calculated metrics, one to account for the agent's tickets and another to account for the group's tickets.
To create the first metric
- In Explore, click the reports (
) icon.
- In the Reports library, click New report.
- On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
- In the report builder, click the calculations icon (
) on the right sidebar.
- Click Standard calculated metric. The Standard calculated metric panel opens.
- In the Name field, type a name for your new metric, in this example, "Madison's tickets".
- In the Formula field, paste the below formula and replace the name of the agent with the agent name you want to report.
IF [Assignee name]="Madison Davis" THEN [Ticket ID] ENDIF
Warning: If your Explore account is not in English, copying and pasting this formula doesn’t work. For a workaround, follow the steps outlined in the article: How can I convert Explore formulas from English into another language? - Click Save.
To create the second metric
- In Zendesk Explore, click the reports (
) icon.
- In the Reports library, click New report.
- On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
- In the report builder, click the calculations icon (
) on the right sidebar.
- Click Standard calculated metric. The Standard calculated metric panel opens.
- In the Name field, type a name for your new metric, in this example, "Support's tickets".
- In the Formula field, paste the below formula and replace the name of the group with the group name you want in your report.
IF [Assignee name]="Support" THEN [Ticket ID] ENDIF
- Click Save.
The report will show you the number of tickets assigned to your agent and the number of tickets assigned to the group you are reporting on.
Difference between the tickets assigned to the group and the tickets assigned to the agent
To calculate the difference between the tickets assigned to the group and the tickets that the agent worked on, you can create a third standard calculated metric as it follows.
- n Zendesk Explore, click the reports (
) icon.
- In the Reports library, click New reports.
- On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
- In the report builder, click the calculations icon (
) on the right sidebar.
- Click Standard calculated metric. The Standard calculated metric panel opens.
- In the Name field, type a name for your new metric, in this example, "Difference tickets".
- In the Formula field, paste the below formula and replace the name of the group with the group name you want in your report.
IF [Ticket Assignee]!="Madison Davis" AND [Ticket group]="Support" THEN [Ticket ID] ENDIF
- Click Save.
12 comments
Teki
Hi. The issue i have with this approach is that you will need to hard code each agent name. Is there a way to use the same principle but compare any agent against the team he/she is in. We have created a set of agent names as an attribute. (using the SET in the calculated attributes in a query.)
2
derrek jennings
Hello
What would this look like if we wanted to compare solved cases per month over the last 12 months? And that would be the final solved, I do not want to double count solved instances.
So I want to see
Ticket Group X Solved cases (displaying monthly for the last 12 months)
Team Member A Solved Cases (displaying monthly for the last 12 months)
Thank you
0
Giuseppe
Hi Derrek,
We can do this by modifying the Calculated Metric to only include the Solved tickets. As per the article Metrics and attributes for Zendesk Support, the formula for the Solved Ticket metric is:
We can add this to the above formula like this:
1.) Create the metric for the agent:
2.) Create the metric for the group:
You can then add these 2 to the Metrics. Then in the Rows, add Ticket Solved - Month attribute, which you can then filter to only show the the last 12 months.
Thank you!
0
D.Fitz
Is there any way to recreate this dynamically without the need to manually hardcode agents' names? Creating individual calculated metrics for a growing team of 50+ agents isn't viable so would be great if there was another way to pull this together
0
Dane
As it turns out, we don't have dynamic filters yet. All should be done manually.
0
Sana Stephens
Why can't we use current user instead of hardcoding the agent's name?
0
James G
I'm sorry to inform you that this feature is currently not available. When utilizing the [Assignee name] attribute in the formula, we need to explicitly state the assignee's name as we don't have a feature that can automatically adjust its value depending on who is accessing the report like [Assignee name] = current viewer. For now, the option we have is to manually specify the name of the assignee in the formula.
0
Tiziano Di Rauso
It is annoying that we can't get this to work using Data Filters in our dashboards. Filtering by Assignee name would be a great way to have the metric dynamically change for each agent. I'm sure this is a feature that would be appreciated by any Zendesk user managing a team
0
James G
We have a feature in our beta dashboard that is similar to what you're looking for - Dynamically adapting dashboard data based on viewer.
However, for this particular situation, we need to include the assignee name in the formula of the custom metric, which is why it is currently not possible to dynamically change the assignee name indicated in the formula.
0
Tiziano Di Rauso
Correct this won't work because the goal here is to allow manager to view agent performance vs team performance. The moment you adapt the data for a specific agent, you loose the capability of comparing it with the broader team data.
What we need is to be able to use the complete agent list as a filter in custom metrics, that way you can have the data dynamically change by changing the dashboard filter to the agent you which to adapt the data for.
0
James G
That is correct!
It seems like there isn't any feedback about this topic yet. I suggest sharing your thoughts on our page here - Feedback - Reporting and analytics (Explore).
0
Tiziano Di Rauso
Submitted the idea for dynamic filtering of metrics based on Assignee here https://support.zendesk.com/hc/en-us/community/posts/7110038339098
0