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.