14 Replies Latest reply: Aug 14, 2018 6:31 AM by Bala Bhaskar RSS

    reference to dimension itself in set analysis

    Глеб Аитов

      hi!

       

      i have FUNNEL2 dimension, which is dual:

       

      Funnel2NUM(Funnel2)amount
      ready1100
      steady280
      go350

       

      Is there way to write something like this is set analysis:

       

      amount_previous = SUM (  {<Funnel2={< " $( =num(Funnel2)-1 ) " >} >}   amount).

       

       

      Funnel2amount_previous
      ready-
      steady100
      go80

       

      alternatively, i can create Funnel2_previous dimension in the script. Can I use it like this?

      amount_previous = SUM (  {<Funnel2={< " $( =text(Funnel2_previous))" >} >}   amount).

       

      Thank you!