For that set of reports you may want to leverage a rule to fetch the most recent scores for each customer and transforms them to a "color" value and then calculate the %. This could be stored in a data space for your desired visual





After the initial fetch & transform, it could be followed by a calculation of the sum of each color value divided by the distinct count of cusotmer ID's in the space as your denomentator.





% color = (sum of color 😵 / (count distinct of customer ID)





Fetch -> Transform -> Calculate -> Store Values -> Display





Not sure the coffee has hit me yet but maybe?

---

Hi Angela -





You can accomplish this by fetching from your scorecard fact object. In the show field, choose count of Account ID and the by field will be "label" from your scorecard fact object.





Then, you'll see that within your scorecard fact object, you'll have access to a "measure" table via a join on the measure ID. Pull the "Name" from that object, and use it to filter down to whatever measure you're looking to see. You should then be able to display a nice-looking red/yellow/green pie chart with percentages for each label (red/yellow/green).

---

Super, thanks Spencer. It worked beautifully!!!

---