Forum Discussion
Dynamic Grid for Dashboard
After looking at this a bit, I was able to figure out. Solution is super easy, though I don't know how optimal it will be as data sets get larger. Posting this for reference for anyone in the future.
On the left hand side, the metric name comes from the static table along with the goal and weight. The score is then put in using an: if(values(Metrictext) = "MetricName1", [MetricScore1],
if(values(Metrictext) = "MetricName2", [MetricScore2],... and so on and so on. I'll do the same calculation for the "Status" option. We'll see how it performs with 30 different metrics but may be the only solution.
Any help available on this topic or other recommendations for how to display is greatly appreciated.
After looking at this a bit, I was able to figure out. Solution is super easy, though I don't know how optimal it will be as data sets get larger. Posting this for reference for anyone in the future.
On the left hand side, the metric name comes from the static table along with the goal and weight. The score is then put in using an: if(values(Metrictext) = "MetricName1", [MetricScore1],
if(values(Metrictext) = "MetricName2", [MetricScore2],... and so on and so on. I'll do the same calculation for the "Status" option. We'll see how it performs with 30 different metrics but may be the only solution.