4 Replies Latest reply on Sep 12, 2018 4:03 AM by Ashish Shah

    Data source filter for a moving window.

    Ashish Shah

      Hi All,

       

      I am facing some challenge in putting a data source filter which needs to be a moving window of 12 months. I need the filter to get me data for last 8 months (current month including) and next 4 months (i.e. total 12 months). When I try to do this in datasource filter using "Relative Dates" section. First filter with the option 'Last' gives me data for last 8 months INCLUDING current month and second filter on the same field for 'Next' 4 months also includes current month.

       

      I do not want to include current month in the second filter as I am already getting data for it from the first filter.

       

      Can someone suggest how to fix this. My data is at year-month level.

       

      Thanks,

      Ashish