I do something similar (comparing last week’s data with this week’s data, where it resets on Sunday morning, I believe), but it sounds like you want the panel to change once per day and reflect the last 7 days worth of data, correct?
I think you can solve this by playing with the Relative time and Time shift fields shown above. There is a good thread linked below in case you have not seen it yet.