I’m new to Metabase but I’m really interested in the product and considering the Enterprise license. The main aspect I need to solve right now is to have a way to filter my data using the relative dates of complete days of the month, aka “Month D-1” or “This month, without today”.
Using the filter date widget from the dashboard I was able to connect it to a SQL parameter (my questions is SQL query native type). But the filter widget doesnt have any option that correspond to the rule I need, so I went with this: in the widget we left the standard value to be “Current - Month” and in the query we used a “AND NOT” clause to leave the current day out of the results.
So in the end I got the end result I needed, the filter widget is set with the “Month D-1” rule from standard but the user can also change it as he likes. But it would be much more easier if the “Current” option in the date widget also offered the same as the “Previous” and “Next” option, or some “Exclude today” option. That way, the user would realize too whats happening (because “Current month” doesn’t imply the D-1 rule).
Either way, sorry if this is something that has already been adressed, but I looked around in the forum and also the Metabase docs and couldn’t find this suggestion or a similar workaround.