BigQuery SQL for GCP Billing Reports: Getting Total Costs by Project for the last 4 weeks

gcp_billing_costs_by_project.sql

#standardSQL
SELECT 
  project.id AS project_id
  , project.name AS project_name
  , currency
  , ROUND(SUM(cost),2) AS total_cost
FROM `<project_id>.<dataset_id>.gcp_billing_export_v1_XXXXXX_XXXXXX_XXXXXX` 
WHERE _PARTITIONTIME BETWEEN TIMESTAMP(DATE_SUB(CURRENT_DATE(), INTERVAL 28 DAY)) AND TIMESTAMP(CURRENT_DATE())
  AND project.id IS NOT NULL
GROUP BY project_id, project_name, currency
ORDER BY total_cost DESC