Recent searches
No recent searches
Solved Tickets by Agent vs. Agent Average in group
Answered
Posted Nov 11, 2021
Hi! I want to create a query that shows an individual agent's tickets solved per day over a week vs. the average tickets solved by agent per day in the entire group. How do I get the "Average Tickets Solved by an Agent per Day" metric?
1
5
5 comments
ZZ Graeme Carmichael
Abigail
There is a Zendesk provided metric Tickets Solved Daily Average.
You can calculate the same metric at group level using an aggregate function
You can try:
ATTRIBUTE_FIX(SUM(Tickets solved - Daily average), [Ticket group])
and filter your report by Ticket Solved Date for the last week.
The agent average is calculated by taking the number of tickets solved divided by a count of the number of days that have solved ticket data. So if agents are not all solving tickets every day, comparing with the group figure may overstate the performance of agents.
1
Abigail
Thank you!
0
Dayner Carry
Hi,
Similar to the question above, is there a way to get an Solved Ticket average for a select group of agents? For example, I'm looking to calculate the average tickets solved per day per agent for 6 specific agents.
Ultimately I want to be able to show everyone what the average solved tickets per agent per day is so they have a target to meet each day.
Thank you!
0
Francis Casino
Yes, this is possible. I have created a ticket where we can discuss this further.
0
Sarah Madison
I have the same question as Dayner! Was this one able to be solved? Thanks so much in advance!
0