09-08-2017 10:25 AM - edited 03-14-2019 05:34 PM
Hi All,
I'm looking for the SQL query to find the call distribution per agent and per skillgroup, thanks a lot for your help.
BR
Aubert
09-08-2017 11:09 AM
what do you mean by call distribution?
09-08-2017 02:22 PM
It sounds like agents are in multiple skill groups and get calls during the day on those different skill groups and the OP wants to know, for each agent, the number of calls for (e.g.) Sales, the number of calls for Service, the number of calls for Support and so on.
Obviously he should be looking in the Agent_Skill_Group_Interval table.
Regards,
Geoff
09-11-2017 01:22 AM
Hi Slavik,
I would like to query all calls to an agent (Handled, answered,abandonned, etc...) and to a skillgroup ?
BR
Aubert
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide