2 Replies Latest reply: Jan 20, 2012 10:34 AM by delageniere RSS

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



      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 !