3 Replies Latest reply: Feb 12, 2018 9:01 AM by Josh Pinfold RSS

    Colouring a Bar Chart

    Josh Pinfold

      I have a bar chart where the dimension is 'ENPS' (a number scale form 0-10) and two measures which count the number scores for this week and for last week;

       

           count(if(weekstart(today()-1)=weekstart(Feedback_Day_Start),ENPS)) for 'this week'

           count(if(weekstart(today()-8)=weekstart(Feedback_Day_Start),ENPS)) for 'last week'

       

      Does anyone have an expression that would enable me to change the colours of the two bars.

       

      I thought if(weekstart(today()-1)=weekstart(Feedback_Day_Start),rgb(10,174,255)) would colour the 'this week' bar and leave the other grey but it didnt work,

       

      Thanks