I have a scenario where the table looks like this.
MetricName, VariableName
m1, v1
m2,v2
m3,v3
m4,v4
I need to display a chart with "MetricName" and the result of the evaluation of the variable in a chart. Let us say the variable contains sum(<field>).
Can't get it to work. Anyone tried this. Please see the attachment. However it works when you select just one metric.
It's not possible in this way because you will need $-sign expansion to evaluate the expression and this will be caluculated only once before the chart is calculated and then applied for each row. Therefore you will need mandatory an approach with if-loops or better a pick(match()) to get unique expression for each row - whereby this could be applied automatically, see also:
I think do this, you won't even need a synthetic dimension. But I guess the issue is that using pick or if over large number of dimension is what the OP is trying to avoid.
Attaching the non-valuelist version of your proposed solution
