Hello
I have stored all my expressions as variables
I have stored every variable in a spreadsheet and then use the following syntex to load in the variables
Expressions:
LOAD Variable,
Replace(Expression, '$', '#') As Expression
FROM
(biff, embedded labels, table is [Formulas$]);
Let vNumberOfRows =
NoOfRows('Expressions');
For
vI = 0
to (
vNumberOfRows - 1)
Let
vVariable_Name =
Peek('Variable',
vI,'Expression');
Let
[$(vVariable_Name)] =
Replace(
Peek('Expression',
vI,'Expression'), '#', '$');
Next
My chart are now looking at the variables, as I have been told that it will stop the chart calculating the informatoin "on the fly"
So if my charts are not calculating information on the fly anymore, when is the variable performing the calculation and storing the values?
Is it as the spreadsheet loads in?
Any help on understanding why I have been told to take this approach to improve "End user experience" would be greatly appreciated
Thanks
Helen
