Time Filter Pre-Config - Better Performance

What is the problem or goal the end user is trying to solve or accomplish?

The customer would like to have a default filter set on charts that will constrain the time range to a specific range such as 'last week' or 'last month' that will auto apply when in explore. The current set up with no filter causes lags with a refresh due to the time it takes to hit the DB and come back. Use case DB in this scenario is Druid.

How are they solving it currently?

Manually forcing a filter, but if they dont, it results in a long refresh lag.

What is the recommended solution by the Customer?

Enabling the ability to set an auto filter such as 'last week' and removing/modifying if needed.