17 Replies Latest reply: Nov 8, 2017 4:24 AM by Shraddha Gajare

# set analysis without variable panel

Hi Everyone,

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.

• ###### Re: set analysis without variable panel

Try,

sum(

if(

num(((sum([Aggr tTalkComplete]))/1000)+(((sum([Aggr tHeld]))/1000)),vFormatSeconds2) >600 ,1,0

)

)

• ###### Re: set analysis without variable panel

it says "error in expression"

• ###### Re: set analysis without variable panel

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))

• ###### Re: set analysis without variable panel

can you share sample app?

• ###### Re: set analysis without variable panel

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

• ###### Re: set analysis without variable panel

In 2nd Image showing Date & sumbeyond10mins what you have used?

• ###### Re: set analysis without variable panel

Sum(if((sum([Aggr tTalkComplete])/1000)+(sum([Aggr tHeld])/1000)>600,1,0))

Should work in 2nd image

• ###### Re: set analysis without variable panel

i just copied the expression of beyond10mins because i also tried this (exactly what you are suggesting) but says

error.

• ###### Re: set analysis without variable panel

Try using Variables for

sum([Aggr tTalkComplete])/1000

and sum([Aggr tHeld])/1000

and use those variables here

• ###### Re: set analysis without variable panel

try:

Sum(

if(

((sum([Aggr tTalkComplete])/1000)+ (sum([Aggr tHeld])/1000) ) >600, 1, 0 ) )

• ###### Re: set analysis without variable panel

still error

• ###### Re: set analysis without variable panel

if possible share sample data in excel

• ###### Re: set analysis without variable panel

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!!!

• ###### Re: set analysis without variable panel

See Attached app.

Created same expression in Load script.

• ###### Re: set analysis without variable panel

Also you can use this

sum(aggr(if(((sum([Aggr tHeld])/1000)+(sum([Aggr tTalkComplete])/1000))>600,1,0),Date,[Aggr tHeld],[Aggr tTalkComplete]))