Google Analytics weird behaviour in group by

[lucas.lima]

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

[lucas.lima]

Just found an open issue:

Issue: Google Analytics question shows days/weeks/months off by one

[lucas.lima]

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