In Explore, I'm working on a dashboard to show an agents stats for the quarter. I'd like to be able to compare that to the team stats.
So Agent A is on a team made of up Agents A, B, C, & D. Agent C is no longer on the team, but was earlier this quarter. I can show the count of tickets for Agent A in the quarter, but I want to compare that to the average or median of tickets for the team (agents A, B, C, & D). How can I get the avg of tickets for the team? The team changes often, so I don't want to build a metric to just divide by the current total number of team members.
It would also be great if I could show this on the same graph - Agent A ticket count compared the the avg ticket count per agent for the team of 4 agents.
Any creative ideas?
Please sign in to leave a comment.