![[PukiWiki]](image/owl.png "[PukiWiki]")
記事:
${__field.labels.__values}
# or
${__field.labels.col1}
select TIMESTAMP('2025-01-01 00:00:00') as time, 10 as cost union all select TIMESTAMP('2025-02-01 00:00:00') as time, 20 as cost
記事:
サンプルダッシュボード:
クエリ例:
SELECT TIMESTAMP(format_timestamp('%Y-%m-01 00:00:00', usage_start_time, 'UTC')) AS start_time, round(SUM(cost)) AS cost FROM billing-export-kii.billing.gcp_billing_export_v1_00011E_BCB6C1_EBC83E WHERE $__timeFilter(usage_start_time) AND cost >= 0.01 GROUP BY start_time ORDER BY start_time
SELECT TIMESTAMP(format_timestamp('%Y-%m-01 00:00:00', usage_start_time, 'UTC')) AS start_time, project.name AS project, round(SUM(cost)) AS cost FROM billing-export-kii.billing.gcp_billing_export_v1_00011E_BCB6C1_EBC83E WHERE $__timeFilter(usage_start_time) AND cost >= 0.01 GROUP BY start_time, project ORDER BY start_time, project
SELECT TIMESTAMP(format_timestamp('%Y-%m-01 00:00:00', usage_start_time, 'UTC')) AS start_time, service.description AS service, round(SUM(cost)) AS cost FROM billing-export-kii.billing.gcp_billing_export_v1_00011E_BCB6C1_EBC83E WHERE $__timeFilter(usage_start_time) AND cost >= 0.01 GROUP BY start_time, service ORDER BY start_time, service
