7 Replies Latest reply: Jul 10, 2013 5:00 AM by Borja Rodriguez RSS

    Only load data of last 4 weeks

      Hi,

       

      I want to load data only from the last 4 weeks, I tried below but it's not working:

       

      LOAD week,

      data,

      data,

      data,

      data,

      color

      FROM table

      where 'week'>=$(=Max(week))-3 and color='BLUE';

       

      Anyone can help?

       

       

      Peter