Query: cloud_billing_report_cost_by_location_dashboard_location_costs

select
  project_id as "Project",
  coalesce(location.region, 'global') as "Location",
  location.zone as "Zone",
  round(sum(cost), 2) as "Total Cost",
  currency as "Currency"
from
  gcp_billing_report
where
  ('all' in ($1) or project_id in $1)
group by
  project_id,
  project_name,
  location.region,
  location.zone,
  currency
order by
  sum(cost) desc;