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...
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.
Thanks a lot!!!
Retrieving data ...