Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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