11-11-2011 08:17 AM - edited 03-14-2019 08:52 AM
Would anyone happen to know of a SQL query that that can be run on the HDS what would give the avarage skillgroups assigned to an agent. Also, another one that would give average number of agents to a supervisor?
Solved! Go to Solution.
11-12-2011 02:57 PM
Hi,
try
SELECT COUNT(*)/CAST(COUNT(DISTINCT sgm.AgentSkillTargetID) AS FLOAT) FROM Skill_Group_Member sgm
and
SELECT COUNT(*)/CAST((SELECT COUNT(DISTINCT SupervisorSkillTargetID) FROM Agent_Team_Supervisor) AS FLOAT) FROM Agent_Team_Member
But please remember agents don't have to be in teams, so the above query does not count with agents who aren't assigned to a team.
G.
11-12-2011 02:57 PM
Hi,
try
SELECT COUNT(*)/CAST(COUNT(DISTINCT sgm.AgentSkillTargetID) AS FLOAT) FROM Skill_Group_Member sgm
and
SELECT COUNT(*)/CAST((SELECT COUNT(DISTINCT SupervisorSkillTargetID) FROM Agent_Team_Supervisor) AS FLOAT) FROM Agent_Team_Member
But please remember agents don't have to be in teams, so the above query does not count with agents who aren't assigned to a team.
G.
11-12-2011 03:24 PM
Thanks Gergely!
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: