Visual Cues Question

[spyrosd80]

Hi,

I have a table chart and one column has number values sorted ascending.

I need to give red color to the 20% of the lowest values and green to the rest. I thought it would be easy but I have stuck somehow...

Any thoughts?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

You can use the rank function. See attached example. Click on the + in front of the expression (or dimension) and then click on Background Color to see the expression used for the color.

[spyrosd80]

It worked!

Thanks a lot!!!