TABLE FILE AHTDIV SUM AHTDIV.AHTDIV.calls AS 'Calls,Ans' COMPUTE AHT/D8.2 = IF calls EQ 0 THEN 0 ELSE ( acdtime + acwtime + holdacdtime ) / calls; COMPUTE AVGTalk/D8.2 = IF calls EQ 0 THEN 0 ELSE acdtime / calls; AS 'AVG Talk' COMPUTE AVGACW/D8.2 = IF calls EQ 0 THEN 0 ELSE acwtime / calls; AS 'AVG ACW' COMPUTE AVGHold/D8.2 = IF calls EQ 0 THEN 0 ELSE holdacdtime / calls; AS 'AVG Hold' BY AHTDIV.AHTDIV.EmpDivisionName AS 'Division/SkillName' BY LOWEST AHTDIV.AHTDIV.SkillName ON AHTDIV.AHTDIV.EmpDivisionName RECOMPUTE AS '*TOTAL' HEADING "PNC Call Center Average Handle Time Report" "Between <+0>&dte<+0> and <+0>&edte" " " FOOTING "" ON TABLE SET PAGE-NUM OFF ON TABLE SUMMARIZE AHTDIV.AHTDIV.calls AVGTalk AVGACW AVGHold AHT AS 'TOTAL' ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = ENgray_theme, $ TYPE=DATA, COLUMN=N1, FOCEXEC=group( \ DIV=N1 \ dte=&dte.QUOTEDSTRING \ edte=&edte.QUOTEDSTRING \ ), $ TYPE=DATA, COLUMN=N2, JUSTIFY=LEFT, $ TYPE=TITLE, COLUMN=N2, JUSTIFY=LEFT, $ ENDSTYLE END
quote:TYPE=TITLE,
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |