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 |
|---|---|---|---|---|---|---|
| % Abd - Split | NUMBER | Sum | {0,number,0.0%} | ifError(sum([hsplit_abncalls])/sum([hsplit_callsoffered]),0) | ||
| % Abd - VDN | NUMBER | Sum | {0,number,0.0%} | ifError(sum([hvdn_abncalls])/sum([hvdn_incalls]),0) | ||
| % ACD - Split | NUMBER | Sum | {0,number,0.0%} | ifError(sum([hsplit_acdcalls])/sum([hsplit_callsoffered]),0) | ||
| % Agent Occupancy | NUMBER | Sum | {0,number,0.0%} | ifError(sum([hagent_i_ringtime]+[hagent_i_acdtime]+[ACD Other Time - Agent by Split] +[ACD Aux Outbound Calls - Agent by Split]+[ACD Aux Inbound Calls Talk Time - Agent by Split] +[hagent_i_acwtime])/(sum([hagent_ti_stafftime])-sum([hagent_ti_auxtime]) +sum([ACD Aux Outbound Calls - Agent by Split]) +sum([ACD Aux Inbound Calls Talk Time - Agent by Split])),0) | ||
| % Service Level - Split | NUMBER | Sum | {0,number,0.0%} | ifError(sum([hsplit_acceptable])/sum([hsplit_callsoffered]),1) | ||
| % Service Level - VDN | NUMBER | Sum | {0,number,0.0%} | ifError(sum([hvdn_acceptable])/sum([hvdn_incalls]),0) | ||
| AHT - Agent | NUMBER | Sum | iferror((sum([hagent_acdtime])+sum([hagent_acwtime])+sum([hagent_holdtime]))/sum([hagent_acdcalls]),0) | |||
| AHT - Split | NUMBER | Sum | iferror((sum([hsplit_acdtime])+sum([hsplit_acwtime])+sum([hsplit_holdtime]))/sum([hsplit_acdcalls]),0) | |||
| AHT - VDN | NUMBER | Sum | iferror((sum([hvdn_acdtime])+sum([hvdn_acwtime])+sum([hvdn_holdtime]))/sum([hvdn_acdcalls]),0) | |||
| Avg Abd Time - Split | NUMBER | Sum | ifError(sum([hsplit_abntime])/sum([hsplit_abncalls]),0) | |||
| Avg Abd Time - VDN | NUMBER | Sum | ifError(sum([hvdn_abntime])/sum([hvdn_abncalls]),0) | |||
| Avg ACD Time - Agent | NUMBER | Sum | ifError(sum([hagent_acdtime])/sum([hagent_acdcalls]),0) | |||
| Avg ACD Time - Agent by Split | NUMBER | Sum | ifError(sum([hagent_i_acdtime])/sum([hagent_acdcalls]),0) | |||
| Avg ACD Time - Split | NUMBER | Sum | ifError(sum([hsplit_acdtime])/sum([hsplit_acdcalls]),0) | |||
| Avg ACD Time - VDN | NUMBER | Sum | ifError(sum([hvdn_acdtime])/sum([hvdn_acdcalls]),0) | |||
| Avg ACW Time - Agent | NUMBER | Sum | ifError(sum([hagent_acwtime])/sum([hagent_acdcalls]),0) | |||
| Avg ACW Time - Agent by Split | NUMBER | Sum | ifError(sum([hagent_i_acwtime])/sum([hagent_acdcalls]),0) | |||
| Avg ACW Time - Split | NUMBER | Sum | ifError(sum([hsplit_acwtime])/sum([hsplit_acdcalls]),0) | |||
| Avg ACW Time - VDN | NUMBER | Sum | ifError(sum([hvdn_acwtime])/sum([hvdn_acdcalls]),0) | |||
| Avg AUX Extn In Time | NUMBER | Sum | ifError(sum([hagent_auxintime])/sum([hagent_auxincalls]),0) | |||
| Avg AUX Extn Out Time | NUMBER | Sum | ifError(sum([hagent_auxouttime])/sum([hagent_auxoutcalls]),0) | |||
| Avg Extn In Time | NUMBER | Sum | ifError(sum([Inbound Extension Call Talk Time])/sum([Inbound Extension Calls]),0) | |||
| Avg Extn Out Time | NUMBER | Sum | ifError(sum([Outbound Extension Call Talk Time])/sum([Outbound Extension Calls]),0) | |||
| Avg Hold Time - Agent | NUMBER | Sum | ifError(sum([hagent_holdtime])/sum([hagent_holdcalls]),0) | |||
| Avg Hold Time - Split | NUMBER | Sum | ifError(sum([hsplit_holdtime])/sum([hsplit_acdcalls]),0) | |||
| Avg Speed Ans - Split | NUMBER | Sum | ifError(sum([hsplit_anstime])/sum([hsplit_acdcalls]),0) | |||
| Avg Speed Ans - VDN | NUMBER | Sum | ifError(sum([hvdn_anstime])/sum([hvdn_acdcalls]),0) | |||
| Date | DATE | Latest | {0,date,yyyy/MM/dd} | dateTrim([timestamp],"DayOfMonth") | ||
| Duration Format HH:mm:ss | CONTENT_ATTRIBUTES | Latest | <duration; pattern "h:mm:ss"> | |||
| Inbound Extension Call Talk Time | NUMBER | Sum | sum([ACW Inbound Extension Calls Talk Time - Agent])+sum([hagent_auxintime]) | |||
| Inbound Extension Calls | NUMBER | Sum | sum([ACW Inbound Extension Calls - Agent])+sum([hagent_auxincalls]) | |||
| Outbound Extension Calls | NUMBER | Sum | sum([ACW Outbound Extension Calls - Agent])+sum([hagent_auxoutcalls]) | |||
| Outbound Extension Calls Talk Time | NUMBER | Sum | sum([ACW Outbound Extension Calls Talk Time - Agent])+sum([hagent_auxouttime]) | |||
| Week Begin | DATE | Latest | {0,date,yyyy/MM/dd} | let [wd]=weekday([timestamp]) if([wd]=1,[Date],addDays([Date],1-[wd])) |