5 Replies Latest reply: Feb 26, 2013 6:56 AM by Kiran V RSS

    How to change data according to start and enddate?

    Saumya Shah

      I created variables named StartDate and EndDate

      Then in slider/calendar object i selected =Min(Date) as minvalue and =Max(Date) as maxvalue

      start date.JPG

      similarly for variable EndDate i choosed =$(StartDate) as minvalue and -Max(Date) as max value

      enddate.JPG

      then in a barchart in expression i wrote

      =Sum(if( Date>=$(StartDate AND Date <=$(EndDate),Field1))

      But chart is not responding accordingly