Yearly filter

King_Edward · April 9, 2019, 12:37am

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)?

AndrewMBaines · April 9, 2019, 7:33am

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

King_Edward · April 9, 2019, 4:03pm

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).

flamber · April 9, 2019, 4:13pm

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

AndrewMBaines · April 10, 2019, 6:54am

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