2 Replies Latest reply: Oct 6, 2017 1:25 AM by Rajan Kasbe RSS

    Change bar chart color if value is above average.

    Justin Dallas

      Hello Folks,

       

      I've got a simple bar chart, with an Average calculation reference line.  Thus far, it looks like this.

       

      BarChart.PNG

       

      What I would like is that when the Bar is above the reference line, it's Blue and when it's below the reference line it's Green

       

      My expression looks like so: 

       

      If( Count(Order) > Avg(Aggr(Count(Order),[Scheduled Week])), Blue(), Green())

       

      But not matter what, the bar is ALWAYS green.  What should I be using to get this to work?  For instance, the value 226 should be Blue as it is above the average and the value of 184 is below the average.

       

      Any help is greatly appreciated.