[Perc Total - Over time - Part 1] How to compute a percentage of total in BigQuery using SQL #SQL #BigQuery

categories_over_time.sql

WITH
  revenue_product AS (
  SELECT
    product_category,
    DATE(DATE_TRUNC(order_date,MONTH)) AS order_month,
    ROUND(SUM(product_revenue),0) AS revenue_per_category
  FROM
    `datastic.variables.base_table`
  GROUP BY
    1,
    2)
  -- Main Query
SELECT
  *
FROM
  revenue_product