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.
You can Edit your Table Calculation so that it returns Null if there are not enough marks, and then ctrl-drag-and-drop that table calc pill onto the Filter shelf, and from the special tab, keep only non-null values.