colour field of a dimension based on its value, is this possible?

[chriscools]

Hello,

i have a dimension called OrderDate for which i calculate 2 expression.

is it possible that if the orderdate is more than 30 days ago, the values for the expression or dimension become red?

thanx!

chris

[Gysbert_Wassenaar · Accepted solution]

Yes, if you click on the + sign in front of a dimension or expression you can then click on Background Color (or Text Color) and enter an expression to calculate a color. Something like if(today() - OrderDate> 30, red(), black())

[chriscools]

perfect, thanx!