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

image avatar

ZZ Graeme Carmichael

Community Moderator

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


Thank you!

0


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


image avatar

Francis Casino

Zendesk Customer Care

Hello Dayner,
 
Yes, this is possible. I have created a ticket where we can discuss this further. 

0


I have the same question as Dayner! Was this one able to be solved? Thanks so much in advance!

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post