This content has been marked as final. Show 3 replies
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
do i have to use an expression for each KPI? and add something to the background colour of each expression?