We’ve just released Metabase 50, including big improvements to caching, permissions, charts that look the same in subscriptions as they do in Metabase, a new command palette, lots of visualization upgrades and more.
This update broke a bunch of our queries that were calculated using the query builder for a same day last week calculation. It now ends up taking two days into account instead of one. Leaving a few details of how the queries are set up so you can try and replicate.
For example:
This filter should only include my records from the same day last week (last tuesday aug 27).
For some reason, the query is actually including the day after (aug 28) in the calculations. When I group by day, i can see that it is including BOTH aug 27 and aug 28.