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

# reference to dimension itself in set analysis

hi!

i have FUNNEL2 dimension, which is dual:

Funnel2NUM(Funnel2)amount
go350

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

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

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

• ###### Re: reference to dimension itself in set analysis

Sort by Funnel2 and use expression as Above(Amount)

• ###### Re: reference to dimension itself in set analysis

Yeah, it's true when I use a table. However, I need it as a standalone solutions, when there is no other cells to refer to.

• ###### Re: reference to dimension itself in set analysis

Well you will have to reference some field right? For the first row you can have a check and pick a start value then on the following rows you can use Above()....

• ###### Re: reference to dimension itself in set analysis

what is your UI expectation ?

• ###### Re: reference to dimension itself in set analysis

i need to count those, which were ready, steady, go, but not sold

count( {<

funnel2=

*P({<funnel2={<"funnel2-1">} >})

*E({<funnel2={<"funnel2">} >})

>}

distinct funnel2)

The question is what is should put instead of Bold text.

UI expectation:

funnel2count
go0
sold1
• ###### Re: reference to dimension itself in set analysis

Try this

amount_previous = SUM (  {<Funnel2={< " \$( =above(Funnel2))" >} >}   amount)

• ###### Re: reference to dimension itself in set analysis

no, it's not working - returns '-'