Can I now define 3 variables which does straight calculations on those fields, so I declare those formulas once in my script, and I can use the variable name in my charts instead of doing the whole calculation per chart again?
so for example, can I add the following lines to my loadscript? :
vApples = amount_apples / total_amount;
vOranges = amount_oranges / total_amount;
vOthers = amount_other_fruit / total_amount;
Now I would like to make a chart, showing the avg % apples per country.
Yes, you can use precalculate values and hold them in variables for reusing them in different chart objects.
Those precalculated values normally won't be sensitive to dimension values, though (e.g. ..per country).
You can also store the expression definition (i.e. the 'text' of an expression) in variables and reuse those in chart objects, but here they will be calculated in each chart object, being sensitive to dimension values.
Latter is more a kind of maintenance help then an improvement in calculation performance.
The main difference about the two is how you define them (using LET or SET in script, using or not using the equal sign in variable overview).
If you calculate values in variables, and these variables are used in the charts then it would not split the values by dimension, it shows the same values for all the values in the dimension.
Instead of that, create a variable with formula without using the Set.
Yes, you can use precalculate values and hold them in variables for reusing them in different chart objects.
Those precalculated values normally won't be sensitive to dimension values, though (e.g. ..per country).
You can also store the expression definition (i.e. the 'text' of an expression) in variables and reuse those in chart objects, but here they will be calculated in each chart object, being sensitive to dimension values.
Latter is more a kind of maintenance help then an improvement in calculation performance.
The main difference about the two is how you define them (using LET or SET in script, using or not using the equal sign in variable overview).
