Colors in bar chart

[#1]

Hi,

I want to have two colors on the bars in a chart. The bars are calculated through a if statement:

if ( something * something = something, true, false )

in the case above I have a date dimension, so for all true I want the bar to be green and for all false I want the bar to be red. Is this possible and how should I write the script?

Thanks!

[#2 · Accepted solution]

Hi,

this can be done in following way:

in Expressions tab of the bar chart properties expand expression item and you will find there its 'Background color' attribute. In definition for that attribute add if(<your_date_condition>, RGB( 50,  140, 3), RGB( 250,  4, 3))

regards