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

    set analysis without variable panel

    Isabel Encinas

      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