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_total_cost
Usage
powerpipe query gcp_cloud_billing_insights.query.cloud_billing_report_cost_by_project_dashboard_total_cost
SQL
select 'Total Cost (' || currency || ')' as label, round(sum(cost), 2) as valuefrom gcp_billing_reportwhere ('all' in ($1) or project_id in $1)group by currencylimit 1;
Params
Args | Name | Default | Description | Variable |
---|---|---|---|---|
$1 | project_ids |
Dashboards
The query is used in the dashboards: