Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I really need your expertise.
I'm thinking to create a variable for Talk + Hold.
vTalkHold = num(((sum([Aggr tTalkComplete]))/1000)+(((sum([Aggr tHeld]))/1000)),vFormatSeconds2)
then I will do the below expression in sheets. sum(if([vTalkHold]>600,1,0))
But I do not have a variable panel access so I have to directly have this measure in master Item.
Please advise
try:
Sum(
if(
((sum([Aggr tTalkComplete])/1000)+ (sum([Aggr tHeld])/1000) ) >600, 1, 0 ) )
that's my problem. I do not have access to variable panel
still error
if possible share sample data in excel
sorry.. how to attach excel file here?
but here's the simple data sample that you may input to excel.
the Aggr THeld and Aggr TTalkComplete are in millisecond format. that is why I am dividing them to 1000.
After dividing them, I have to add Aggr tHeld + Aggr TTalkComplete. if the total is more than 600sec then count as 1. so in the example i should have 2 data that is greater than 600sec
this should be the result
Super Thanks!!!
See Attached app.
Created same expression in Load script.
Also you can use this
sum(aggr(if(((sum([Aggr tHeld])/1000)+(sum([Aggr tTalkComplete])/1000))>600,1,0),Date,[Aggr tHeld],[Aggr tTalkComplete]))