Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have a field that contain an expression
i added in the end a sample of my table
in my UI i have a screen that i must choose one metric
and in this screen i want to create a chart that the expression of the chart will be the exp field
how can i do it?
is there a way of doing that without a variable?
adi
metric | exp |
---|---|
1 | sum(amount) |
2 | avg(amount) |
3 | min(amount) |
x
cccccccc
how many metric values you have? change accordingly as you required.
Take Straight Table
ValueLoop(1,3) -- Give name as metric
Expression may be using this
If(ValueLoop(1,3)=1, Sum(amount), If(ValueLoop(1,3)=2, Avg(amount), If(ValueLoop(1,3)=3, Min(amount))))
Or
Pick(Match(ValueLoop(1,3),1,2,3), Sum(amount), avg(amount), min(amount))
hi. but for this solution i dont need the expression in the field...
the idea is that the expression is dymanic and extract from a table.
adi
May be like this,