0 Replies Latest reply: Jan 22, 2013 4:09 PM by 967872 RSS

    Conditional Colouring of Waterfall Graph/Chart

    967872
      Hello to all OBIEE people

      Im trying to set the colour 'RED' to a section of the graph when there is a negative variance compared to the previous value

      There are 6 values in the graph/chart and they are in this order:
      Revenue, Committed, HL, ONW, Adjustments, Revenue_Year_End.

      I say 'values' because they are all values from the same column called (Measure).

      What im trying to do is have any value turn RED when its worth less then the previous one. So if ONW = 6 and Adjustments = 5 then Adjustments turns RED and so on....

      Would that be possible given that they are all values from the same column (Measure) or is there an actuial way that it can be done?

      Here is a link of what the chart currently looks like:
      http://imageshack.us/photo/my-images/23/waterfallw.png/

      Any reply is much appreciated!

      Thank you

      Edited by: todays_special on 21/01/2013 22:25

      Edited by: todays_special on 22/01/2013 14:08