as the picture, how to auto set filter by now(yyyymm)?? I must manual control the filter at every month begin.
Hi @Jay
You will need to use Field Filters for that:
https://www.metabase.com/learn/sql-questions/field-filters
But I create all the question by [simple question mode]. Do I need change all the questions to [sql question]??
@Jay Then you will need to convert your data to a date type, so Metabase can understand what it is.
But to answer your question: you'll have to manually update that filter, since your data is created in a way that isn't following any standards, which makes it difficult to work with.
Or you can create a script, which automatically updates the dashboard filter every month via the API:
https://github.com/metabase/metabase/blob/master/docs/api-documentation.md