Default date filter value

Get Help
1

We have been using Metabase for some time now and are facing an issue we have not been able to resolve on our own.

We frequently write complex native MongoDB queries. Our data includes date fields (start and end), and in our dashboards we have configured start and end date filters. The query logic returns all records that overlap with the selected start and end filter values.

The challenge we are experiencing relates to setting a default value for these filters. Specifically, we would like the default date range to be the last two months.

  1. When using a “Date” filter type, there does not appear to be an option to set the default value to “2 months ago.”
  2. When using a field filter instead, it gets converted into a full query rather than passing only the date value. This creates a problem because we need to reference the filter value elsewhere within our native query.

Is there a good solution/approach for the problem I am facing?

Thanks!

2

We use the API to set filter values to defaults. Just need to have a good naing convention.

1 Like
3

Hi Andrew,

I was hoping that it would be easier to set this up using the UI but I guess that it is not supported.
I tried your suggestion and it does work so I will just build a service that updates the default.

Thanks a lot for your help!

4

Have you tried creating a Snippet of the filter query? In modern Metabase versions, they can take parameters.