I have a SQLITE datasource, dates are stored as ISO date string (YYYY-MM-DD HH:MM:SS.SSS). Building a query which groups by one of these date fields “binned” by month works fine. However, binning by YEAR returns multiple ‘2019’ for each year permutation in the dataset.
Metabase: 34.0
OS: CentOS
Hi @brianwilson
Interesting bug. I haven’t figured out where the problem is (if it’s a driver issue or something in Metabase).
I guess your only workaround is to create the query in SQL.
I’ve created an issue for this:
https://github.com/metabase/metabase/issues/11615 - upvote by clicking 
on the first post