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

    Color by Expression (Green - Red - Yellow)

    Lauren Mills

      Hello,

       

      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?