Hi, I was wondering whether it would be possible to easily filter relative date/time values that are between two arbitrary values, eg.:
between -5 and -2 days
between -3 and +3 hours
between +3 and +8 minutes
other than glueing together multiple interval() statements (especially the second case is quite tricky) so that average user can formulate this kind of filter.
Relative date filter custom intervals
Hi @dfx413
The Custom Expression interval()
is currently not easiest option:
https://www.metabase.com/docs/latest/users-guide/expressions.html
There's work being done in the upcoming version 0.43, which will add more relative filter options - some of the work is still pending and the feature might get pushed to 0.44.
Follow this issue:
https://github.com/metabase/metabase/issues/4083 - upvote by clicking on the first post
1 Like