Change default filter by Current date

Get Help
1

Hi guys,
I've created one default filter for dates in my SQL Queries.
example: variable for {{init_date}} and {{final_date}} and I using between in my queries.

  1. is it possible to change the default {{init_date}} and {{final_date}} variables default in Dashboard? example:
    [Showing 2022-10-01 - 2022-10-31] and set do default values {{init_date}} and {{final_date}} for this dates and for next month set the default values for October ??

  2. If it's possible to add variables into Dashboard and use into ansewrs and queries should be interesting (like: master detail reports).

edit: I see the Filter into dashboard and I've added one Date filter into Dashboard how can I use the dashboard filters into questions and queries sql? is it possible?

2

Hi @lucas.dj

  1. Why not use Field Filters instead of single dates? I cannot see your query, so cannot tell if it will work.
    https://www.metabase.com/learn/sql-questions/field-filters
  2. I'm not sure what you are asking for.

Have you looked at https://www.metabase.com/docs/latest/dashboards/filters

3

Hi flamber, thank you so much.

  1. is it possible to use a field Filter with Between for Date in where clause?
  2. I mean if is it possible to set Dashboard filter date and this dashboard filter pass by parameter for variable into SQLCommand ?

Example: Dashboard 1, click set filter Date dashboard and this filter date pass to my variables inside the sqlcommand.

4

@lucas.dj Yes, have a look at both links I provided.

1 Like