EXPRESSION IN FIELD

[adiarnon]

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

[Anil_Babu_Samineni]

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))

[adiarnon]

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

[muthukumar77]

May be like this,