Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
To make expressions not to complicated, I stored some expressions in variables. The stored expressions contain variables too.
Should it be possible to use variables like this. For every dimension I get the same result now.
For example : stored in var1 = sum({<year={"=$(var_chosen_year)"}>}sales)
var2 = sum({<year={"=$(var_compare_year)"}>}sales)
In my chart :
dimension : department
expression: $(var1)-$var(2)
SOLVED : I created the content of the variable starting with the "=" sign". Without that character it works
SOLVED : I created the content of the variable starting with the "=" sign". Without that character it works
Hi
For Dynamic, remove the "=" equal sign from the formula and try like $(var1)
var1:
sum({<year={"=$(var_chosen_year)"}>}sales)