Untitled
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