Dynamic Grid for Dashboard

[nmcclary]

Hey everyone,

I have received the request in the screenshot below for an organization wide dashboard. I know how I will build most of it but what I can't figure out how to approach is the grid on the right. In this example, there are 24 metrics coming from 10-15 different sources. Each of these are different calculations. I can easily make a grid that has the values but what I can't figure out is how to get the target, score, and weight to transfer over. The target, score, and weight will be housed in another static table. What's the best way to approach this?

Also, the end user would like the feature where you highlight a metric title and the box in the lower middle will populate with the information listed. I believe I can figure this out but if anyone has quick tips there, that is appreciate as well.

Thank you,

Nick

[nmcclary]

Any help available on this topic or other recommendations for how to display is greatly appreciated.

[nmcclary · Accepted solution]

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.