10 Replies Latest reply on Nov 5, 2015 6:52 PM by Bill Lyons

    Filter for last 10 days of data

    Yan Wu



      I have a time series dataset and I would like to chart only the last 10 days of data.  I am having trouble creating this filter.


      1)  No data on weekends as these are business days.  Thus, I cannot simply use date math.

      2)  I would like to show 10 days of data from the latest date in the dataset, thus I cannot use something like TODAY()-10.

      3)  There's more than 1 data per day, and thus, I cannot use INDEX() or LAST() to construct it.


      Any help would be appreciated.  Thank you!