Hi,
I installed the latest version of Metabase and saw the period functionality.
For example, when I filter using :
"value":"past1months",
To retrieve last month data.
My question, is it possible to extract the date of the period?
Hi,
I installed the latest version of Metabase and saw the period functionality.
For example, when I filter using :
"value":"past1months",
To retrieve last month data.
My question, is it possible to extract the date of the period?
Hi @Exe
Your would have to use something like concat(year(), month(), day())
together with datetimeSubtract()
https://www.metabase.com/docs/latest/questions/query-builder/expressions-list
And then you'll do that twice for first and last period.
How do I use it ? Inside my SQL query ?
@Exe Then you should probably start out by saying that you're using SQL and Field Filters instead of showing screenshots from the GUI.
Have a look here: Date range filter for custom field - #2 by flamber