4 Replies Latest reply: Jul 18, 2016 8:54 AM by bruno bertels RSS

    Color by Expression

    Lauren Mills

      Hello Folks!


      Question. I have a bar chart (see below). I currently have them sorted by the measure of highest % to lowest %. I want the highest % bar (regardless of the percent) to be green then a slow fade to yellow for the mid bar and slow fade to red to the lowest bar. I want them to match the style of my gauge (see below).


      Any ideas how to write this expression? Let me know if more information is needed. Thanks!


      Bar Chart - Green fade to yellow fade to red



      Theme I want the bars to match ^



      Dimensions = [BC]

      Measure = Count({$<[LEVEL 0 COMPLETION]={"Y"},[LEVEL 1 COMPLETION]={"Y"},[LEVEL 3 COMPLETION]={"Y"}>}SID)/Count(SID)