Query: cost_and_usage_actual_overview_dashboard_top_10_resource_groups

select
  resource_group_name as "Resource Group",
  round(sum(cost_in_billing_currency), 2) as "Total Cost",
  billing_currency as "Currency"
from
  azure_cost_and_usage_actual
where
  ('all' in ($1) or subscription_id in $1)
group by
  resource_group_name,
  billing_currency
order by
  sum(cost_in_billing_currency) desc
limit 10;