Block Chart & Background Colours

[wonkymeister]

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.	KPI	Actual	Target
A	KPI1	$75	$100
A	KPI2	$1000	$3000
A	KPI3	$200	$150

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

cheers

[wonkymeister]

basically,

is it possible to specify the colour of each individual block?

[giakoum]

KPI1 has value Actual $75

where is that coming from if not an expression, even if it is Only(Actual)?

Based on that, you can set the color as desired

[wonkymeister]

the data is already calculated prior to load.

i understand where your coming from now - i was trying to save time and have the calculation already done in the dataset - save me doing the calculation in the chart.