I was wondering if there is a way to take a single dimension in looker and conditionally format to a specific choice or selection in looker.
So if I have one dimension named “brand” and my measure is “recommend score” my data is set up like this:
BRAND Recommend Score
brand A 56%
brand B 66%
brand C 54%
brand D 57%
brand E 62%
where i want to make the chart highlight brand C in a different color automatically, and if I were to select another brand (i.e. Brand A, B, D, or E) it would highlight in a third color.
So eventually I may have a chart that looks like this:
If there is a way you think I would need to set this up in the SQL portion / just in the visualization itself that would be much appreciated!