Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
let's try replacing set analysis with if condition as below:
amount_previous = SUM( if( Funnel2 = above(Funnel2), amount, 0 )
it will never be true by definition
it does not work
what should means : status = {<"$(above(status))"} in your set analysis ?
you can use above (Complete expression) right for this scenario, either way you will get same output.
May be this:
For status:
Status = {"=$(=(Above(Status)))"}
Refer these: