We'd love a way to set a relative date range (i.e. last 8 days or current week) but exclude the current day from the range. Ideas for how to accomplish this: A checkbox on the date selector or "last" becomes a drop down and there's also "previous" for "previous 8 days (preceding today)". Add the "current date" to a column on one of the transformed tables. That way I could create a filter inside a custom metric that says date is not current date.