hi!
i have FUNNEL2 dimension, which is dual:
| Funnel2 | NUM(Funnel2) | amount |
|---|
| ready | 1 | 100 |
| steady | 2 | 80 |
| go | 3 | 50 |
Is there way to write something like this is set analysis:
amount_previous = SUM ( {<Funnel2={< " $( =num(Funnel2)-1 ) " >} >} amount).
| Funnel2 | amount_previous |
|---|
| ready | - |
| steady | 100 |
| go | 80 |
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!
