I’m using a Date Range filter in my dashboard, and I want to remove the “Any Time” option from the filter dropdown (as shown in the attached screenshot). I would like to limit the available options to specific date ranges like “Is in the month”, “is in the year”, etc., to prevent users from selecting “Any Time”.
Is there any way to configure the Date Range filter to achieve this?
I don’t know if you can disable a specific filter value, but you can set a default filter value so that users have to go out of their way to search ‘any time’. And if you are concerned that they will be searching a large amount of data, you could always limit how much they can search by applying a ‘sql always where’ filter on the explore to limit the time horizon they can go back over to the last year, two years, or whatever.