How do I color a dimension consisting two fields with same expression?
Hi, I have a dimension based on the formula
IF(len(trim([CONTAINER]))=0,'OFF-LINE','ON-LINE') as OFF_ON_LINE
The expression for the above dimension is count(distinct case#).
How can I color the cells in straight table such a way that for OFFLINE below 70 is red and above 70 is green, and for ONLINE below 110 is red and above 110 is green?