Colour Gradient For Table Column

[JJ141]

Hi all,

I am looking for a way to colour each column with the smallest number having the lightest number and the largest number having the darkest colour.

The expression I have tried is:

ColorMix1(
rank( total(
<expression for the column>
)
)
, $(vColorMixLight), $(vColorMixDark))

which gives me the attached result.

Any help would be greatly appreciated. 🙂

[Cybb9870]

colormix1 function 's first part should between 0~1, your rank function's result will start from 1; I think that's why only 1 color is showed on the screen, maybe you can consider to change it~