This appears to be available in the Gravity and Formidable Forms addon, but my source data is not a form. Please make “filter by last X time period” part of the core plugin! Specifically:
“Default initial view on load = last X days”
“Users can still expand range after load”
“Works for non-SQL sources like Google Sheets / linked tables”