Untitled

 avatar
user_3592770
sql
10 days ago
1.4 kB
5
Indexable
SELECT 
    (SELECT COUNT(DISTINCT dialerid) 
     FROM `p-cdh`.primaryactive.dialer 
     WHERE calltypecode='INBOUND' AND IsActiveFlag = 'true') AS Total_Answered_Calls,

    (SELECT COUNT(DISTINCT dialerid) 
     FROM `p-cdh`.primaryactive.dialer 
     WHERE ringtimeduration <= 180 AND calltypecode='INBOUND' AND IsActiveFlag = 'true' AND talktimeduration >= 1) AS Answered_Calls_CEPAL,

    (SELECT COUNT(DISTINCT dialerid) 
     FROM `p-cdh`.primaryactive.dialer 
     WHERE ringtimeduration > 180 AND calltypecode='INBOUND' AND IsActiveFlag = 'true' AND talktimeduration >= 1) AS Answered_Calls_External,

    (SELECT COUNT(DISTINCT dialerid) 
     FROM `p-cdh`.primaryactive.dialer 
     WHERE dialertype = 'cti_ivr' AND IsActiveFlag = 'true' AND talktimeduration >= 1) AS Self_Service_Calls,

    (SELECT ROUND(100.0 * COUNT(DISTINCT CASE WHEN TalkTimeDuration IS NULL OR TalkTimeDuration = 0 THEN dialerid END) / NULLIF(COUNT(DISTINCT dialerid), 0), 2) 
     FROM `p-cdh`.primaryactive.dialer 
     WHERE calltypecode = 'INBOUND' AND IsActiveFlag = 'true') AS Abandoned_Rate,

    (SELECT ROUND(100.0 * COUNT(DISTINCT CASE WHEN dialertype = 'cti_ivr' AND talktimeduration >= 1 THEN dialerid END) / COUNT(DISTINCT CASE WHEN talktimeduration >= 1 THEN dialerid END), 2) 
     FROM `p-cdh`.primaryactive.dialer 
     WHERE IsActiveFlag ='true') AS Percentage_of_IVR_Calls;
Editor is loading...
Leave a Comment