AnsweredAssumed Answered

Dashboard Selector to display last 7 values

Question asked by jjohnson_washoe on Sep 28, 2020
Latest reply on Oct 2, 2020 by jjohnson_washoe

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?

Derek Law

 

Jay

Outcomes