Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a kind of unique request. I would like to make a basic what if analysis using only variables. I have no data loaded and only variables defined with sliders with min, max and step size values. I would like to create charts that compare the values calculated by two sets of sliders. Basically it would have 2 dimensions item 1 and item 2 with expressions one calculated with one set of sliders and the other with the other set. Basically dimension 1 values would be slider 1 *slider 2 and dimension 2 would be slider 3 * slider 4.
Is there a way to do this and if so how?
Thanks!
Like this?
Expression: =If(Dimension = 'Item1', vVar1 * vVar2, vVar3*vVar4)
Do you have two dimensions or 1 dimensions with two fields in it (Item1 and Item 2)?
Sorry one dimension with 2 fields
I want the expression value for each field to be different and be a result of selected values of sliders.
Like this?
Expression: =If(Dimension = 'Item1', vVar1 * vVar2, vVar3*vVar4)