Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have an island table as the following
id | var | exp |
1 | vMetric1 | Sum(A) |
2 | vMetric2 | Sum(B) |
3 | vMetric3 | Sum(A)*Sum(B) |
4 | vMetric4 | Sum(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?
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