cost_and_usage_actual_cost_by_resource_group_dashboard_monthly_costcost_and_usage_actual_cost_by_resource_group_dashboard_resource_group_costscost_and_usage_actual_cost_by_resource_group_dashboard_subscriptions_inputcost_and_usage_actual_cost_by_resource_group_dashboard_top_10_resource_groupscost_and_usage_actual_cost_by_resource_group_dashboard_total_costcost_and_usage_actual_cost_by_resource_group_dashboard_total_resource_groupscost_and_usage_actual_cost_by_resource_group_dashboard_total_subscriptionscost_and_usage_actual_cost_by_service_dashboard_monthly_costcost_and_usage_actual_cost_by_service_dashboard_service_costscost_and_usage_actual_cost_by_service_dashboard_subscriptions_inputcost_and_usage_actual_cost_by_service_dashboard_top_10_servicescost_and_usage_actual_cost_by_service_dashboard_total_costcost_and_usage_actual_cost_by_service_dashboard_total_servicescost_and_usage_actual_cost_by_service_dashboard_total_subscriptionscost_and_usage_actual_cost_by_subscription_dashboard_cost_and_usage_actual_cost_by_subscription_detailscost_and_usage_actual_cost_by_subscription_dashboard_monthly_cost_and_usage_actual_cost_by_subscriptioncost_and_usage_actual_cost_by_subscription_dashboard_subscriptions_inputcost_and_usage_actual_cost_by_subscription_dashboard_total_costcost_and_usage_actual_cost_by_subscription_dashboard_total_subscriptionscost_and_usage_actual_cost_by_tag_dashboard_monthly_costcost_and_usage_actual_cost_by_tag_dashboard_subscriptions_inputcost_and_usage_actual_cost_by_tag_dashboard_tag_key_inputcost_and_usage_actual_cost_by_tag_dashboard_tag_value_costscost_and_usage_actual_cost_by_tag_dashboard_top_10_tag_valuescost_and_usage_actual_cost_by_tag_dashboard_total_costcost_and_usage_actual_cost_by_tag_dashboard_total_subscriptionscost_and_usage_actual_overview_dashboard_daily_costcost_and_usage_actual_overview_dashboard_monthly_costcost_and_usage_actual_overview_dashboard_subscriptions_inputcost_and_usage_actual_overview_dashboard_top_10_resource_groupscost_and_usage_actual_overview_dashboard_top_10_resourcescost_and_usage_actual_overview_dashboard_top_10_servicescost_and_usage_actual_overview_dashboard_top_10_subscriptionscost_and_usage_actual_overview_dashboard_total_costcost_and_usage_actual_overview_dashboard_total_subscriptions
Query: cost_and_usage_actual_cost_by_service_dashboard_monthly_cost
Usage
powerpipe query azure_cost_and_usage_insights.query.cost_and_usage_actual_cost_by_service_dashboard_monthly_costSQL
select strftime(date_trunc('month', date), '%b %Y') as "Month", consumed_service as "Service", round(sum(cost_in_billing_currency), 2) as "Total Cost"from azure_cost_and_usage_actualwhere ('all' in ($1) or subscription_id in $1)group by date_trunc('month', date), consumed_serviceorder by date_trunc('month', date), sum(cost_in_billing_currency) desc;
Params
| Args | Name | Default | Description | Variable |
|---|---|---|---|---|
| $1 | subscription_ids |
Dashboards
The query is used in the dashboards: