Page History

...

SELECT      (Various Aggregations)
FROM        JTELStats.StatisticsPartA a
LEFT JOIN   JTELStats.AcdStatisticsPartB acdb
    ON      a.ID = acdb.StatisticsPartAID
LEFT JOIN   JTELStats.StatisticsPartB b
    ON      acdb.ID = b.AcdStatisticsPartBID
WHERE       ( a.ClientsID = _ClientsID )
            AND
            ( a.dtCallStart BETWEEN _Timeslice_Begin AND TIMESTAMPADD( MINUTE, 15, _Timeslice_Begin ) )
            AND
            ( a.bOutbound = 0 )
GROUP BY    a.ID;

Partitioning and Aggregations 

When the data is aggregated, it is divided into several consistent partitions, according to the following logic. The resulting aggregations then either count a call, if a condition is met, or determine the time between two timestamps.

Inbound and Outbound

Inbound: ServiceNumber_* Fields

Partitions all records only using fields from StatisticsPartA.

Inbound: ACD_* Fields

Partitions records only for which an AcdStatisticsPartB record exists, and for which it is not a group transfer or group overflow.

...

( AcdStatisticsPartB.ID IS NOT NULL ) AND ( AcdStatisticsPartB.AcdOriginGroupsID IS NULL )

Inbound: Queue_* Fields

Further partitions records which have entered the ACD, only calls which enter the queue.

...

( AcdStatisticsPartB.dtQueueStart IS NOT NULL )

Inbound: Queue_Serviced_* Fields

Further partition on calls which entered the queue, only calls answered by an agent are considered (calls were definitely offhook). The condition used is:

...

( StatisticsPartA.dtCallConnect IS NOT NULL ) AND ( AcdStatisticsPartB.dtAgentConnect IS NOT NULL )

Inbound: Queue_NotServiced_* Fields

Further partition on calls which entered the queue, and were offhook, only calls not answered by an agent are considered. The condition used is:

...

a.bCallerHangup = 0  --> System hangup (Reject)
a.bCallerHangup <> 0  --> Caller hangup (Abandoned)

Inbound: AgentCalls_*, GroupTransfer_*, AgentTransfer_*, NumberTransfer_* Fields

Only records which meet the following condition are considered:

...