1 Reply Latest reply on Mar 3, 2012 9:47 AM by Joe Mako

    Exclude first 14 days from chart

      I have a chart that shows a metric which is a rolling 14-day average. I'd like to exclude the first 14 days from this chart, as they'll be low by definition. I dont want to exclude the first 14 days from the partition, however: I want to exclude the first 14 days from the entire dataset (ie I dont want to show any data if the data is within the first 14 days of the ENTIRE dataset, regardless of what date range the user is looking at)

       

      I've tried doing this a few ways without any luck. Any ideas? INDEX() shows the row number of the current partition, not the entire dataset, so it's useless.