This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I used the period over period structure above and combined it with the
join on false approach here to do something similar on Google BigQuery.
Goal: Compare any two arbitrary periods from the same table with varying
levels of granularity (e.g. broken...