Preset Feature Feedback
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.
This function would be really helpful for improving our performance in Preset.
Background:
We’ve had multiple incidents where Preset dashboards/charts became very slow or went down. Root cause: some tables/charts were run without a time range filter, so queries scanned the entire historical dataset and consumed excessive compute resources.
Request:
When a dataset has a temporal column, new charts should default to a time range (e.g., Last 7 days, configurable).
If a user runs a query without any time filter, show a warning / require confirmation, and offer a one-click “Apply Last 7 days” option to prevent accidental full-history scans.
This would reduce platform instability caused by accidental unbounded queries.
it would be nice if the filter we put on "Autocomplete query predicate" will be added automatically on the filter box when exploring a new chart page