Column chart colouring based on condition(Edit Chart Config)

Looker Q&A Looker
1

Hi Team,

I am working on a column chart and need to implement conditional coloring.

Specifically, I want the bars for the Count measure to be Blue when the Flag dimension/measure(hide from visualisation) equals ‘1’ and Grey otherwise. Since Looker’s standard Chart Config Editor cannot directly reference a secondary field for coloring, could you help me implement one of the following?

Please let me know which approach works best.

(Based on flag(dimension/measure(hidden from visulisation)) I need to apply colours to my column chart)

cc : @sam8 , @Lobo-Google

Thank you

2

You should be able to reference a secondary field for coloring! Look at this example: Customizing visualizations using the Chart Config Editor  |  Looker  |  Google Cloud Documentation