Google Analytics weird behaviour in group by

#1

As simples as the images show:

Metabase is messing up the date field, both in group by and for the query filter as well (if I don’t query Analytics adding the 12AM time value, metabase adds another day to the count, making the values differ from those shown in Analytics).

Any workarounds? I can’t group by month, and that hurts my dashboard :frowning:

#2

Just found an open issue:

#3

Also, just a workaround - group by “Month of the year”, instead of “month”. That will give you a string - not ideal (since you lose year data, which needs to be shown in another separated column), but usable (in my case at least).