How to change the color of a bar according to a calculated dimension ?

[#1]

Hello,

I would like to change the color of the bar of the graph according to a calulated dimension.

It works fine with a "basic" dimension, using the background color attribute in the expression menu using for example :

=if(completeness > limitCompleteness, green(), red())

with completeness the dimension.

But I f a use a calculated dimension, for example, :

=if(SessionStartDate>=V_StartDate, if(SessionStartDate<=V_EndDate,

round(if(completeness >= $(limitCompleteness),completeness,$(limitCompleteness)),0.5)

, null()), null())

then the color of the bar is no more changed.

Do you have any idea why ?

Thanks in advance !

[#2]

Hi Delageniere,

Can you try to write the same color format expression in expression background color instead of writing in dimension BG color

If still it didnt worked plz let me know

Meher

[#3]

Hi Merwan,

Thanks for your answer, but it is already in the Expression background color.

I do not see any background color in the dimension menu ?

Solange