Field filter functionality for dates

Hello,

I saw the different field filters for time/dates but I am thinking there is a functionality missing to easily select a certain year ( or certain multiple years/month. )

If I want to have data for 2017 I have to use the time range filter which seems quite complicated to me for such a task.

Lets say I want Jan/2016 and Mar/2018 and 2019 - how can that be accomplished with the given filters?

You could just write a simple SQL query that would give you data for the year you would type in. It would look something like this:

SELECT * FROM data
WHERE to_char(data.date, ‘YYYY’) = {{year}}

The year here would be a simple text representation of the given year you want to get info about.

That is indeed a good workaround, but having a set of specialized time filters, I think that should be a option that is available by default.

@susman
It sounds like you’re looking for a way to have a dropdown with a custom list of options? Then the following two requests might be of interest - upvote by clicking :+1: on the first post:
https://github.com/metabase/metabase/issues/5245
https://github.com/metabase/metabase/issues/6820