Query: cloud_billing_report_cost_by_service_dashboard_service_costs

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