Weekly revenue

Completed-order revenue by week since a start date you pick.

From

Running…

View SQL

SELECT date_trunc('week', created_at)::date AS week,
       round(sum(total)) AS revenue
  FROM sample.orders
 WHERE status = 'completed'
   AND created_at >= {{start_date}}::date
 GROUP BY 1
 ORDER BY 1