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
Also you can use this
sum(aggr(if(((sum([Aggr tHeld])/1000)+(sum([Aggr tTalkComplete])/1000))>600,1,0),Date,[Aggr tHeld],[Aggr tTalkComplete]))
Try,
sum(
if(
num(((sum([Aggr tTalkComplete]))/1000)+(((sum([Aggr tHeld]))/1000)),vFormatSeconds2) >600 ,1,0
)
)
it says "error in expression"
I have also tried this but still shows "error in expression"
sum(if(num(sum([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000))>600,1,0))
can you share sample app?
Talk Hold = sum(([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000)
beyond 10mins = if((sum([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000)>600,1,0)
so the problem is this.. the sumbeyond10mins should show 4
Thank you Shraddha!
In 2nd Image showing Date & sumbeyond10mins what you have used?
Sum(if((sum([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000)>600,1,0))
Should work in 2nd image
i just copied the expression of beyond10mins because i also tried this (exactly what you are suggesting) but says
error.
Try using Variables for
sum([Aggr tTalkComplete])/1000
and sum([Aggr tHeld])/1000
and use those variables here