Look at the SQL produced by Metabase, it hans't done the TIMESTAMP_TRUNC in this custom column for the join, which then does not bring the right results: I am using BigQuery as a database, and ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback