0 Replies Latest reply: Feb 28, 2018 10:05 AM by Gregory Di Pasquale RSS

    color expression in bar diagram

    Gregory Di Pasquale

      Hi,

      I have a bar diagram with 1 dimension and 2 measures :

       

      Capture3.PNG

      I would like to use diffrent colors for my bars in comparing them.

      For example, I would like that for a given month, the biggest value will be set in green and the lowest in red.

      Is it possible by simply comparing the 2 bars ?

      Or should I create a color expression using the code of my bars ?

       

      Code behind bars :

      column 1 :

      Sum({$<OPERATION_VALUE_DATE.autoCalendar.Year={2017}>}OPERATION_ACCRUED_INT_AMOUNT_EUR)


      column 2 :

      Sum({$<[OPERATION_VALUE_DATE.autoCalendar.Year] = {2018}, [OPERATION_VALUE_DATE.autoCalendar.Date] = {"<=28/02/2018"}>}OPERATION_ACCRUED_INT_AMOUNT_EUR)

       

      I've tried to write such expression but without success.

      Perhaps there is a simple way to do that ?

       

      Thanks for your help.