6 Replies Latest reply: Feb 6, 2017 12:59 PM by Melissa Pluke RSS

    Color Bars if Greater than average.

    Melissa Pluke

      Screen Shot 2017-02-05 at 10.15.10 PM.png

      Hi all, I have a graph that has an average revenue per month.  I want the bars to change color (from grey to purple) if the bar is greater than the average.  That average will change each month, so I would like it to be able to automatically update.

      I tried if(sum(Revenue)>avg(Revenue),rgb(115,71,156),rgb(165,175,182)) but that doesn't seem to work.  I can only get it to work if I hardcode the average number in there.  like this: if(sum(Revenue)>116,rgb(115,71,156),rgb(165,175,182))

      Any ideas? Thanks!