3 Replies Latest reply: Feb 19, 2016 8:00 AM by Tresesco B RSS

    Setting color based on value being selectable ( date range selection/navigation )

    Mika Lindman

      I'm drawing a bar chart with date as dimension and sum( {1} Data.Counter ) as expression, to get a full view of item count over time.

      img_1.png

      I'd like to set the color of currently selected dates, like this

      img_2.png

      I know I can set color in the properties of the expression

      img_3.png

      But I can't figure out the if -expression I should use. Does anyone know how to achieve this? What I'm looking for is something like

       

      if ( CurrentDate IN SelectedDates, RGB(0, 0, 0), RGB(255, 255, 255) )