Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
How to avoid auto refresh of graph when using complex expression in it? I am using a line chart with complex expression and we have inline table for filter and it is not associated with data model.
but when selecting values in this filter. Chart with complex expressions is getting refresh every time. So is there any way to avoid this Issue.
If any solution please let me know
Thanks,
Satya
In Add-Ons section you can add a calcualtion condition like only calculate when a variable=1, then you can add a button to 'Calculate', when the user clicks that button it changes the value of a variable to '1'.
The same button can change it's label to 'stop calculate' if the user wants to select different values, the value set for variable could be:
=If(varName=1,0,1)
Same for label: =If(varName=1,'Stop calculate','Calculate')