I have a COVID dashboard that includes a list of daily case numbers. I'd like to have a selector that has options to display data for either the last 7 days OR various other time frames. I'm currently using the Date Selector, but the problem is that depending on the current time of day and on the date/time associated with the data records, when I use the "within last 7 days" I get either 6 OR 7 values.
I understand that this is an expected behavior, based on a very literal, precise interpretation of "Last 7 Days" that includes TIME (so the filter would be more properly named "Last 168 hours"). What I need is to show the last 7 daily values. My human users expect to see 7 values when they ask for the last 7 day's values.
Is there any way to do this with the dashboard Selectors?