Calculated fields
Calculated fields are created from measures. They use existing measures to calculate new measures.
Display name |
Type |
Tags |
Aggregator |
Display format |
Attributes |
Formula text |
---|---|---|---|---|---|---|
AHT | NUMBER | Calabrio | Sum | ifError((sum([aqd_talktime])+sum([aqd_holdtime])+sum([aqd_worktime]))/(sum([aqd_callcount])-sum([acd_rna])),0) | ||
Avg Abandon Time | NUMBER | Calabrio | Sum | ifError(sum([cqd_time_abandoned])/sum([cqd_Abandoned]),0) | ||
Avg Speed of Answer | NUMBER | Calabrio | Sum | ifError(sum([cqd_time_before_handled])/sum([cqd_Handled]),0) | ||
Call End Time - CCD | DATE | Calabrio | Latest | {0,date,HH:mm:ss} | [Call End Datetime - CCD] | |
Call Start Time - CCD | DATE | Calabrio | Latest | {0,date,HH:mm:ss} | [Call Start Datetime - CCD] | |
Calls Abandoned % | NUMBER | Calabrio | Sum | {0,number,0.0%} | ifError(sum([cqd_Abandoned])/sum([queuecount]),0) | |
Calls Dequeued % | NUMBER | Calabrio | Sum | {0,number,0.0%} | ifError(sum([cqd_calls_dequeued])/sum([queuecount]),0) | |
Calls Handled % | NUMBER | Calabrio | Sum | {0,number,0.0%} | ifError(sum([cqd_Handled])/sum([queuecount]),0) | |
ckey | STRING | Calabrio | Latest | text([Node ID])&"-"&text([Session ID])&"-"&text([Session Sequence Number]) | ||
Handle Ratio | NUMBER | Calabrio | Sum | {0,number,0.0%} | ifError((sum([aqd_callcount])-sum([acd_rna]))/sum([aqd_callcount]),0) | |
Hold Time Avg | NUMBER | Calabrio | Sum | ifError(sum([aqd_holdtime])/sum([acd_hold_count]),0) | ||
Idle Time Avg | NUMBER | Calabrio | Sum | ifError(sum([asd_notready_duration])/sum([asd_notready_count]),0) | ||
SL Met % - Only Handled | NUMBER | Calabrio | Sum | {0,number,0.0%} | ifError(sum([metservicelevel])/sum([cqd_Handled]),0) | |
Talk Time Avg | NUMBER | Calabrio | Sum | ifError(sum([aqd_talktime])/(sum([aqd_callcount])-sum([acd_rna])),0) | ||
Work Time Avg | NUMBER | Calabrio | Sum | ifError(sum([aqd_worktime])/(sum([aqd_callcount])-sum([acd_rna])),0) |