Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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
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