My dashboard is filtered on a date to always show the past 7 days of data. The latest date will always be the previous day. For example, today is 8/26. My trend charts will show data from 8/19, 8/20, 8/21, 8/22, 8/23, 8/24, and 8/25. Tomorrow (8/27), it will show data from 8/20 - 8/26 and so on. I've tried using the relative date filter but it will only anchor based on a specific date. I also can't just simply select "Last 7 days" since it takes into account the current day. Obviously, I don't want to have to update that filter every day, especially when my extracts refresh every early morning to have the data from the previous day. How can I accomplish this?