Preset Feature Feedback
What is the problem or goal the end user is trying to solve or accomplish?
A common use-case for time filtering is to look into current day, current week, current month, etc. There isn't a pre-defined filter for these options (such as it is available for previous week/month/year).
How are they solving it currently?
Users need to apply advanced time filter to achieve this goal.
What is the recommended solution by the Customer?
Implement a new category on the Range Type called Current to easily filter for:
Current day
Current week
Current month
Current year
The workaround is to use the Advanced option, where you can specify the START date with something like:
datetrunc(datetime("today"), year))
This will filter for the ‘current year’. You can change theyeartoweek,month, orquarterto get the current time grain accordingly.datetrunc(dateadd(datetime("today"), -2, month), month)
Subtracts 2 months from the current date.