Yearly filter


#1

Is there any way to create a filter based on ‘year’ (other than having an extra column for ‘year’ and using field filter on that column)?


#2

Do none of the built-in date functions work for you? You can do a period or prompt for a range etc.


#3

Unfortunately not. What I’m looking for is a filter that shows different years (2019, 2018, …) and user can choose some of them and filter the data. Basically sth like when we have an extra column for year and use a field filter on that column).


#4

I think the extra column is the only way until we have something like:
https://github.com/metabase/metabase/issues/5245
https://github.com/metabase/metabase/issues/6165
https://github.com/metabase/metabase/issues/6820


#5

For now, the only approach is to have a proper calendar table with views for each of the tables to link to.