set analysis

[Syahfira1]

Hello,

Can you help me to understand the set analysis below? 

sum({$< $1, $2, $3, $4, $5, $6, $7, $8, $9 >}[Invoice Signed Amount USD])

I don't understand what does the $1, $2 etc means. I have checked in the Variables Editor but nothing stands there called $1, $2 etc. This set analysis been done by a previous developer on the dashboard that I have took over.

I never encounter such set analysis. Please assist. Thank you.

[rubenmarin · Accepted solution]

Hi, $1, $2 are locations where parameters can be inserted when calling a variable.

I suppose that bold expression is stored in a variable, if the variable is called vInvoiceAmount you can call it as:

$(vInvoiceAmount(Year={$(=Max(Year))}))

After the variable and between parethesys you can add parameter separated with comma, each parameter will go to the $ position

The previous example will end as: sum({$< Year={$(=Max(Year))}, $2, $3, $4, $5, $6, $7, $8, $9 >}[Invoice Signed Amount USD])

To simplify, if you have a variable vSum with content $1 + $2, and you create an expression like =$(vSum(3,4)) the expression will return 7 (wich is 3 + 4)

[Syahfira1]

Hi @rubenmarin , thank you very much for the explanation. 

May I know why we need to do these parameters? What is the function of these parameters?

What is the difference between normal set analysis and parameters set analysis?

Does this improve the calculation time on the dashboard level? But, I thought this is solved where we can store the calculation in master items.

[rubenmarin · Accepted solution]

Hi @Syahfira1, I use them to help with maintenance.

I usually have an excel with the varaiables and expressions use.

One sheet for variables and set analysis parts like:

- vCY: =Max(Year)

- vSetCY: Year={$(vCY)}

- vSetLY: Year={$(vLY)}

Another shhet for expressions, usally each block starts with a 'master' variable for each field with fact data like

- vAmount: Sum({<$1,$2,$3,$4>} Amount)

And I can mount the different variations

- vAmount_CY: $(vAmount($(vSetCY)))

- vAmount_LY: $(vAmount($(vSetLY)))

- vAmount_CY_AdditionalCondition: $(vAmount($(vSetCY),$(vSetCondition)))

- vDifAmount_CY_LY: ($(vAmount_CY)-$(vAmount_LY))

- vPercAmount_CY_LY =($(vDifAmount_CY_LY)/$(vAmount_LY))

And if you need to do the same with margin, just copy and paste and replace Amount to Margin