cloud_billing_report_cost_by_label_dashboard_label_key_inputcloud_billing_report_cost_by_label_dashboard_label_value_costscloud_billing_report_cost_by_label_dashboard_monthly_costcloud_billing_report_cost_by_label_dashboard_projects_inputcloud_billing_report_cost_by_label_dashboard_top_10_label_valuescloud_billing_report_cost_by_label_dashboard_total_costcloud_billing_report_cost_by_label_dashboard_total_projectscloud_billing_report_cost_by_location_dashboard_location_costscloud_billing_report_cost_by_location_dashboard_monthly_costcloud_billing_report_cost_by_location_dashboard_projects_inputcloud_billing_report_cost_by_location_dashboard_top_10_locationscloud_billing_report_cost_by_location_dashboard_total_costcloud_billing_report_cost_by_location_dashboard_total_locationscloud_billing_report_cost_by_location_dashboard_total_projectscloud_billing_report_cost_by_location_dashboard_total_zonescloud_billing_report_cost_by_project_dashboard_monthly_costcloud_billing_report_cost_by_project_dashboard_project_costscloud_billing_report_cost_by_project_dashboard_projects_inputcloud_billing_report_cost_by_project_dashboard_total_costcloud_billing_report_cost_by_project_dashboard_total_projectscloud_billing_report_cost_by_service_dashboard_monthly_costcloud_billing_report_cost_by_service_dashboard_projects_inputcloud_billing_report_cost_by_service_dashboard_service_costscloud_billing_report_cost_by_service_dashboard_top_10_servicescloud_billing_report_cost_by_service_dashboard_total_costcloud_billing_report_cost_by_service_dashboard_total_projectscloud_billing_report_cost_by_service_dashboard_total_servicescloud_billing_report_overview_dashboard_daily_costcloud_billing_report_overview_dashboard_monthly_costcloud_billing_report_overview_dashboard_projects_inputcloud_billing_report_overview_dashboard_top_10_locationscloud_billing_report_overview_dashboard_top_10_projectscloud_billing_report_overview_dashboard_top_10_servicescloud_billing_report_overview_dashboard_total_costcloud_billing_report_overview_dashboard_total_projectscloud_billing_report_overview_dashboard_total_services
Query: cloud_billing_report_cost_by_project_dashboard_monthly_cost
Usage
powerpipe query gcp_cloud_billing_insights.query.cloud_billing_report_cost_by_project_dashboard_monthly_costSQL
select strftime(date_trunc('month', usage_start_time), '%b %Y') as "Month", project_id as "Project", round(sum(cost), 2) as "Total Cost"from gcp_billing_reportwhere ('all' in ($1) or project_id in $1)group by date_trunc('month', usage_start_time), project_idorder by date_trunc('month', usage_start_time), sum(cost) desc;
Params
| Args | Name | Default | Description | Variable |
|---|---|---|---|---|
| $1 | project_ids |
Dashboards
The query is used in the dashboards: