hey, this reminds me of a problem I had reacently, where i had a date column with dates on the last day of the month, i.e.
date, kpi
30.6.2024, 12345
31.7.2024, 45698
....
And on bar chart, Metabase aggregated this dates to
July 2024
August 2024
so one month ahead of what is actually correct
Metabase support told me they are working on a fix for this bug, but temporary solution was in the bar chart settings, to change the scale from "timeseries" to "ordinal".