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 ?

      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 !