2 Replies Latest reply: Jun 27, 2017 8:18 AM by Martin Bacul�k RSS

    Bar chart colors apply based on the expression

    kumarsuresh lulu

      first expression should get blue and second expression some other colors.

      I have written some expression here. but, for both the bars I am getting same color.


      Can any one suggest me on this problem?

       

       

       

       

      if(NumOfFailures=0,

              if((Sum({<CalendarMonth={'$(vMaxMonthYear)'},EquipmentCategory ={'Locomotive'}>}AssetMiles)

              /

              Sum({<CalendarMonth={'$(vPrevMonthYear)'},EquipmentCategory ={'Locomotive'}>}NumOfFailures))>0,

              RGB(35, 164, 145),

              if((Sum({<CalendarMonth={'$(vMaxMonthYear)'},EquipmentCategory ={'Locomotive'}>}AssetMiles)

              /

              Sum({<CalendarMonth={'$(vMaxMonthYear)'},EquipmentCategory ={'Locomotive'}>}NumOfFailures))>0,

              RGB(35, 164, 145),

              RGB(35, 164, 145)

              )

              )

              ,

       

       

              if((Sum({<CalendarMonth={'$(vPrevMonthYear)'},EquipmentCategory ={'Locomotive'}>}AssetMiles)

              /

              Sum({<CalendarMonth={'$(vPrevofPrevMonth)'},EquipmentCategory ={'Locomotive'}>}NumOfFailures))>0,

        RGB(14, 49, 146),

              if((Sum({<CalendarMonth={'$(vPrevMonthYear)'},EquipmentCategory ={'Locomotive'}>}AssetMiles)

              /

              Sum({<CalendarMonth={'$(vPrevMonthYear)'},EquipmentCategory ={'Locomotive'}>}NumOfFailures))>0,

              RGB(14, 49, 146),

              RGB(14, 49, 146)

            

              ))

      )