Untitled

 avatar
user_3592770
plain_text
16 days ago
1.0 kB
3
Indexable
WITH cepal_answered AS (
    SELECT COUNT(DISTINCT dialerid) AS cepal_count
    FROM `p-cdh`.primaryactive.dialer
    WHERE ringtimeduration <= 180
      AND talktimeduration >= 1
      AND calltypecode = 'INBOUND'
      AND IsActiveFlag = 'true'
),
ext_answered 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_answered AS (
    SELECT 
        (SELECT cepal_count FROM cepal_answered) + 
        (SELECT ext_count FROM ext_answered) AS total_answered_count
),
total_calls AS (
    SELECT COUNT(DISTINCT dialerid) AS total_count
    FROM `p-cdh`.primaryactive.dialer
    WHERE calltypecode = 'INBOUND'
      AND IsActiveFlag = 'true'
)

SELECT 
    ROUND(100.0 * (SELECT total_answered_count FROM total_answered) / (SELECT total_count FROM total_calls), 2) AS percentage_answered
FROM dual;
Editor is loading...
Leave a Comment