I have a bar chart where I want to set the colours to red or greeen. Red if the 'follow up year' is <2014 and Green if >=2014.
Then the same for the month ie; if it's Feb in 2014 I want Jan to be red and the other months green.
Hope that makes sense, look forward to you advice!
use the background colour to set
if (year=2014, red(), green())
same for month but you should better set a variable with your last month-year (feb-2014 under date format 01/02/2014) and compare to $(var)
I can't seem to be able to change it in the colour tab, does this need to be done in the script??
the background to modify is in tab "Expression"
Result gives something like this
On the charts Properties | Expressions tab, click the + sign next to the expression and enter the colour expression in the background colour option.The field Year must have a single possible value for each value of the dimensions.
you add the IF Statement here
Following on from Chris's answer, you need to click on the little + next to the expression in the expressions tab, then choose Background Colour
You need to give condition in Background Color option :
Finally it's working!!!! However, my 'others' column is red too and I want this grey. Do I need to add another expression??
Can you share the App?
if you want all others grey but 1 red you set grey color as first color in "Colors" tab and just fix the background color expression (Tab Expression) with a condtion (if (fieldname = value, red())
Retrieving data ...