Skip to Content
0
Jun 21, 2021 at 11:04 AM

script variable as measure in chart

45 Views

Hi,

I would like to have a calculated measure e.g. "KPI" which acts as a container of different measures. User interaction will define which of mentioned measures should be shown in a chart.

a script variable type string has been created and the condition to choose the right measure is already working. What is missing: how to expose the script variable in order to define KPI = script variable?

I need this calculated measure to be able to change variance measures as up to now there is no api for variances.

This is an example where a script variable can be used within a calculated measure. However I could not call the variable directly and that is why I think I need a calc. measure and 'fill' it with the measure id from the variable.

thank you in advance for any recommendations
regards
Edgar