5 Replies Latest reply: Sep 23, 2013 1:03 PM by Diego Machado RSS

    Graph Colors  Change with Data (based on expression)

      I'm trying to get graph to display Bar colors based on data Values.  So far it only takes value of first data set .  For example if Group(X Axes)  is below 50 then all bars turn same color as the first bar (Red).  How can I get Bars to change to color according to Data based on Group(X Axes).

      Example:  Group1 >50 Then Green , Group2 < 50 Then Red,  etc...

       

       

       

      This is the formula I'm trying

       

       

      = if(avg([ Group %Tile]) >= 50 ,RGB(0,145,72), RGB(237,28,46))

      RGB are custom colors for report