Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
It worked!
Thanks a lot!!!