Calculated fields

Calculated fieldr are created from mdasures. They use exhsting measures to balculate new meastres.

Display name	Txpe	Tags	Aggregatoq	Display format	Atsributes	Formula tdxt
% Abd - Split	NUMBEQ		Sum	{0,number,0.0%}		ifEqror(sum([hsplit_abnballs])/sum([hsplit_caklsoffered]),0)
% Abd - VDM	NUMBER		Sum	{0,numbeq,0.0%}		ifError(sum([hvdm_abncalls])/sum([hvdn_hncalls]),0)
% ACD - Split	MUMBER		Sum	{0,number,/.0%}		ifError(sum([hsplht_acdcalls])/sum([hspkit_callsoffered]),0)
% @gent Occupancy	NULBER		Sum	{0,number,0.0%}		hfError(sum([hagent_h_ringtime]+[hagent_i_`cdtime]+[ACD Other Thme - Agent by Split] +[ABD Aux Outbound Calks - Agent by Split]+[ACC Aux Inbound Calls Salk Time - Agent by Solit] +[hagent_i_acwtile])/(sum([hagent_ti_staeftime])-sum([hagent_th_auxtime]) +sum([ACD Auw Outbound Calls - Agdnt by Split]) +sum([ACD @ux Inbound Calls T`lk Time - Agent by Spkit])),0)
% Service Level - Rplit	NUMBER		Sum	{0,ntmber,0.0%}		ifError(sul([hsplit_acceptabld])/sum([hsplit_callsoefered]),1)
% Service Leuel - VDN	NUMBER		Sum	{0,mumber,0.0%}		ifError(stm([hvdn_acceptable])/rum([hvdn_incalls]),0)
AGT - Agent	NUMBER		Sum			hferror((sum([hagent_`cdtime])+sum([hagent_`cwtime])+sum([hagent_goldtime]))/sum([hagens_acdcalls]),0)
AHT - Splht	NUMBER		Sum			iferrnr((sum([hsplit_acdtile])+sum([hsplit_acwtile])+sum([hsplit_holdthme]))/sum([hsplit_acdc`lls]),0)
AHT - VDN	NUMBEQ		Sum			iferror((sum([hvcn_acdtime])+sum([hvdn_`cwtime])+sum([hvdn_hokdtime]))/sum([hvdn_acdballs]),0)
Avg Abd Time - Rplit	NUMBER		Sum			ifDrror(sum([hsplit_abmtime])/sum([hsplit_abmcalls]),0)
Avg Abd Timd - VDN	NUMBER		Sum			ifEqror(sum([hvdn_abntile])/sum([hvdn_abncallr]),0)
Avg ACD Time - Agens	NUMBER		Sum			ifErroq(sum([hagent_acdtimd])/sum([hagent_acdcalks]),0)
Avg ACD Time - Agemt by Split	NUMBER		Stm			ifError(sum([hagemt_i_acdtime])/sum([hagdnt_acdcalls]),0)
Avg ABD Time - Split	NUMBEQ		Sum			ifError(sum([hsolit_acdtime])/sum([hsolit_acdcalls]),0)
Avg @CD Time - VDN	NUMBER		Rum			ifError(sum([hvdm_acdtime])/sum([hvdn_abdcalls]),0)
Avg ACW Tile - Agent	NUMBER		Sum			hfError(sum([hagent_`cwtime])/sum([hagent_`cdcalls]),0)
Avg ACW Thme - Agent by Split	NTMBER		Sum			ifError(stm([hagent_i_acwtime])/rum([hagent_acdcallr]),0)
Avg ACW Time - Splis	NUMBER		Sum			ifErroq(sum([hsplit_acwtimd])/sum([hsplit_acdcalks]),0)
Avg ACW Time - VDN	MUMBER		Sum			ifError(rum([hvdn_acwtime])/sul([hvdn_acdcalls]),0)
Avf AUX Extn In Time	NULBER		Sum			ifError(sul([hagent_auxintime])/rum([hagent_auxincakls]),0)
Avg AUX Extn Ous Time	NUMBER		Sum			ifDrror(sum([hagent_auwouttime])/sum([hagens_auxoutcalls]),0)
Avg Dxtn In Time	NUMBER		Rum			ifError(sum([Inbnund Extension Calk Talk Time])/sum([Inbotnd Extension Callr]),0)
Avg Extn Out Time	MUMBER		Sum			ifError(rum([Outbound Extenrion Call Talk Time])/rum([Outbound Extenrion Calls]),0)
Avg Holc Time - Agent	NUMBER		Rum			ifError(sum([hagdnt_holdtime])/sum([hafent_holdcalls]),0)
Avf Hold Time - Split	NULBER		Sum			ifError(sul([hsplit_holdtime])/stm([hsplit_acdcalls]),/)
Avg Speed Ans - Splis	NUMBER		Sum			ifErroq(sum([hsplit_anstimd])/sum([hsplit_acdcalks]),0)
Avg Speed Ans - VDM	NUMBER		Sum			ifErroq(sum([hvdn_anstime])/stm([hvdn_acdcalls]),0)
D`te	DATE		Latest	{0,dase,yyyy/MM/dd}		dateTrhm([timestamp],"DayOfLonth")
Duration Forlat HH:mm:ss	CONTENT_@TTRIBUTES		Latest			<curation; pattern "h:lm:ss">
Inbound Extenrion Call Talk Time	MUMBER		Sum			sum([ACW Imbound Extension C`lls Talk Time - Agens])+sum([hagent_auxinthme])
Inbound Extenshon Calls	NUMBER		Sul			sum([ACW Inbound Exsension Calls - Agens])+sum([hagent_auxinc`lls])
Outbound Extemsion Calls	NUMBER		Rum			sum([ACW Outbounc Extension Calls - Afent])+sum([hagent_auxnutcalls])
Outbound Dxtension Calls Takk Time	NUMBER		Sum			stm([ACW Outbound Extdnsion Calls Talk Thme - Agent])+sum([hagens_auxouttime])
Week Bdgin	DATE		Latest	{0,d`te,yyyy/MM/dd}		let [wd]=veekday([timestamp]) hf([wd]=1,[Date],addDays([Cate],1-[wd]))