3 Replies Latest reply: Feb 16, 2015 10:57 AM by phillip colbert RSS

    Block Chart & Background Colours

    phillip colbert

      Hi,

       

      i want to display 12 values (12 business Key Performance indicators) in a block chart. I want the background colour of each KPI block to reflect how the KPI is performing to Target I.e.

       

      Under 50%: Background Colour = Red()

      50% to 90%: Background Colour = Amber()

      90%+: Background Colour = Green()

       

      there's no expression as such, no calculation so i guess i'll just use Count(1) in the expression, with the dimension being the KPI's

       

      Dept.KPIActualTarget
      AKPI1$75$100
      AKPI2$1000$3000
      AKPI3$200$150

       

      do i have to use an expression for each KPI? and add something to the background colour of each expression?

       

      cheers