set analysis not using Variable Panel

Anonymous — Tue, 07 Nov 2017 03:13:26 GMT

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

Re: set analysis not using Variable Panel

Anil_Babu_Samineni — Thu, 09 Nov 2017 13:12:14 GMT

Are you getting something when we use this

If(vTalkHold > 600, 1, 0)

If($(vTalkHold) > 600, 1, 0)