Untitled

 avatar
user_3592770
plain_text
3 days ago
1.2 kB
1
Indexable
 (WITH
    -- Calls answered by CEPAL within 60 seconds (ring time ≤ 60)
    cepal_answered AS (
        SELECT COUNT(DISTINCT dialerid) AS cepal_count
        FROM `p-cdh`.primaryactive.dialer
        WHERE ringtimeduration <= 60
        AND talktimeduration >= 1
        AND calltypecode = 'INBOUND'
        AND IsActiveFlag = 'true'
    ),

    -- Calls answered by external within 60 seconds of being presented the call
    -- (after CEPAL didn't answer in 180 seconds, so total ring time 180-240)
    ext_answered_within_60 AS (
        SELECT COUNT(DISTINCT dialerid) AS ext_count
        FROM `p-cdh`.primaryactive.dialer
        WHERE ringtimeduration > 180
        AND ringtimeduration <= 240
        AND talktimeduration >= 1
        AND calltypecode = 'INBOUND'
        AND IsActiveFlag = 'true'
    ),

    -- Total calls answered within effective 60 seconds (either by CEPAL directly
    -- or by external within their 60-second window)
    total_answered_60 AS (
        SELECT
        (SELECT cepal_count FROM cepal_answered) +
        (SELECT ext_count FROM ext_answered_within_60) AS total_answered_60_count
    ),
Editor is loading...
Leave a Comment