18 Replies Latest reply: Jul 27, 2016 11:22 AM by Sunny Talwar RSS

    Color by Expression (Green - Red - Yellow)

    Lauren Mills



      I have a color expression:


      ColorMix2( (rank(total column(1))/(noofrows(TOTAL)/2))-1 ,green(), lightred(),yellow())


      And it gives me the following (which I want):



      But this is a drill-down and it's possible they'll keep clicking until there is only one bar. When there is only one bar - it defaults to the color red.


      I don't want them to think that they were red so why did they change to red. Is there a way to write in the expression to default to a certain color with the drill-down?