Dynamic timeframe grouping

I'd like to control X-axis, which represents the period, and timeframe grouping by day or week using filters on the dashboard.
How would it be possible in Bigquery syntax?

Hi @Anastasiia
That is currently no supported:
https://github.com/metabase/metabase/issues/6583 - upvote by clicking :+1: on the first post

You would currently have to do some complicated workarounds in SQL https://github.com/metabase/metabase/issues/6583#issuecomment-747389799