6 Replies Latest reply: Feb 27, 2014 8:10 AM by Michiel van de Goor RSS

    multiple years in line chart with range selection

    Thorsten Schröder

      Hello community,


      In a line chart I want to display the trend over multiple years plus a range selection the user can set.

      I have to distinguish between CalendarWeek and CalendarMonth. They are mutually exclusive so I show/hide them.


      I've concatenated Year &'-'& CalendarWeek AS YearWeek and Year &'-'& CalendarMonth AS YearMonth but  this doesn't work with the variable I use to select the range.


      SUM({<CalendarWeek={">=$(=Max(CalendarWeek)- ($(vSetCalendarRange)-1))<=$(=Max(CalendarWeek))"}>} Amount)


      Of course Max(YearWeek) doesn't return a value.


      What can I do to fix this so that the range selection works over more than one year?


      Thank you,