Results 1 to 6 of 6

Thread: IC Database calculations

  1. #1
    Join Date
    May 2016
    Location
    Brazil
    Posts
    3

    Lightbulb IC Database calculations

    Hello folks,

    I've been reading the IC Reporting Data Dictionary and when comparing some items I wasn't able to clearly state the difference between them.

    Example:

    Should tAgentAcdCall match with tTalkAcd? In my testings it's close but doesn't match entirely.

    Same happens when I compare tACW with tAgentInAcw, its close but doesn't match.

    My problem is that tTalkAcd and tACW itens don't sum up with tAgentLoggedin time.

    I'm doing a skill group report for a client with basic info such as: TalkTime, Hold, ACW, Available, Auxiliary states such as Break, Personal, Meeting, Training, etc.

    Summing up those times is supposed to match tAgentLoggedin time, but that's not true based on the example above, so I just want to understand which items should I use in my report.

    Thanks,
    Jeff

  2. #2
    Join Date
    Jan 2003
    Location
    Fort Worth, TX
    Posts
    192
    I struggled with the same issue in the past and found this in the Data Dictionary (Agent/Workgroup Queue Period Stats).

    CIC Data Dictionary

    ******************************
    Important Note
    The statistics from tAgent* columns are based on Agents' status changes and interaction state changes. Other ACD statistics from columns such as tExternToInternCalls, tExterntoInternACDcalls, and tTalkACD, are based only on interaction state changes. When reporting on Agent statistics, columns that contain only interaction state changes will not always match to tAgent* columns that contain interaction state changes and status changes. For Agent calculations, use ACD statistics from columns based only on interaction state changes and not on statistics from tAgent* columns.
    ******************************
    Tim Cannon

  3. #3
    Join Date
    Jun 2007
    Location
    Milwaukee, WI
    Posts
    1,207
    Jeff,

    Are you trying to compare values in different tables? It looks like you are pulling values from the agent queue stats and the workgroup queue stats tables and trying to compare results? According to the ININ database guys I have talked to over the years the values will never tie out. The stance is always if you want to look at queue level then use the queue table, if you want to look at agents then use the agent table. If you can give the table name and the column names maybe we can help out on which values you should look at for your report.

  4. #4
    Join Date
    May 2016
    Location
    Brazil
    Posts
    3
    Thanks for the replies guys,

    But in fact I'm only analyzing data from the queue table (IwkrgrpQueueStat) and from one workgroup only.

    If you have some time, please, take a look at the txt I've attached.

    ININ_Database_Analysis.txt

    Try comparing tTalkACD with tAgentOnAcdCall and tAcw with tAgentInAcw for example.

    Also, what really means tAgentNotAvailable? Is it mean the agent is in auxiliary time like break, lunch, etc?

    I've tried to break it down to the AUX codes (tStatus items), but it doesn't match anyway (you can see in the TXT file).

    Thanks,
    Jeff

  5. #5
    Join Date
    Jun 2007
    Location
    Milwaukee, WI
    Posts
    1,207
    Have you checked out the data dictionary? http://help.inin.com/cic/mergedProje...tionary_TR.pdf

    This table is kind of hard to read if you don't understand the usage of the cReportGroup, cHKey3, and cHKey4 columns. The data dictionary does a really good job explaining how to read the values in the table. Take a look and let me know if this answers your questions.

  6. #6
    Join Date
    Jun 2017
    Posts
    2

    Post Short answer

    Re: Workgroup Queue Statistics Interval Table

    Important Note
    The statistics from tAgent* columns are based on Agents' status changes and interaction state changes. Other ACD statistics from columns such as tExternToInternCalls, tExterntoInternACDcalls, and tTalkACD, are based only on interaction state changes. When reporting on Agent statistics, columns that contain only interaction state changes will not always match to tAgent* columns that contain interaction state changes and status changes. For Agent calculations, use ACD statistics from columns based only on interaction state changes and not on statistics from tAgent* columns.
    This is from IC Reporting Data Dictionary Technical Reference Version 3.0 which is the only place I've seen it clearly spelled out.

    http://dii.vermont.gov/sites/dii/fil...Dictionary.pdf

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •