Use expression from field to calculate value

datagrrl — Mon, 03 Apr 2023 15:44:52 GMT

I have created a dynamic dashboard. The correct expression for each metric is determined by the data type and comes in with the data.

What I want the data to look like is this:

MetricID	Value	LowerTarget	UpperTarget
1	7282	500	10000
2	90179	5	100
3	32	1	50
4	16	100	300
5	17391	25	75
6	56551	100	200
7	1394762	50	2000

I have tried a few things, and I can get what I expect for either the maxstring or the minstring or if I select only one metric ID, but I need to get the whole list, like in the image above.

I have attached a sample app and sample data.

TIA

topic Use expression from field to calculate value in App Development

Use expression from field to calculate value