Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
dinnoroni
Partner - Contributor
Partner - Contributor

Evaluate dynamic variables in table

Hi I have an island table as the following

idvarexp
1vMetric1Sum(A)
2vMetric2Sum(B)
3vMetric3Sum(A)*Sum(B)
4vMetric4Sum(A)/Sum(B)

 in my scripts, I loop through the table build out variables dynamically.

In the dashboard I creating a table using id as the dimension and Maxtstring(var) is my expression. How can I evaluate the variables and get the value?


Labels (2)
1 Reply
marcus_sommer

It's not possible because within the UI is no classical evaluate() available. The only exception is a $-sign expansion but it creates an ad-hoc variable which has always a single global value which is evaluated at first and then applied to all rows  / columns - means you couldn't apply it within a dimensional context.

- Marcus