Skip to Content
author's profile photo Former Member
Former Member

Why are the sums from FactCEMAgents and FactCEMContacts differing

Hi there!

Im still trying to figure out why I'm seeing noticeable differences in reporting database results.

Currently I'm focusing on the number of handled inbound calls per agent. For example let's look at the agent with primary key of 8.

In FactCEMAgents she has number of handled calls of 631 for April. Taking the same data from FactCEMAgents I get 616.



Am I filtering the contacts wrong or is somethingf wrong with the system's statistics gathering?


Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Posted on Jun 12, 2017 at 12:17 PM

    Hello Jaanus,

    The is not necessarily anything wrong. The reason for different figures are the different points of view: Agent vs. Contact.

    The same contact can be “handled” by several agents. It is still the same contact when it is first “handled” by an agent and forwarded to another agent who also “handles” it. A contact can also be “handled” by forwarding to another service queue after timeout, without any action by an agent.

    Try to find a smaller set of contacts where the figures mismatch and go through the detailed contact history to see what happened during the contact life cycle and what causes the difference.

    Kind Regards,


    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 13, 2017 at 01:08 PM

    In addition to Tomi's comment, please also clarify the used cctr version, so it is possible to check if there is any difference in that regard.


    Add comment
    10|10000 characters needed characters exceeded