Report application cost month over month

Source: FOCUS 1.0 sample
Result rows: 3
Status: Adapted to v1.0
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Monthly effective cost by service for one application tag value. MONTH() becomes a YYYY-MM label so years are not merged. The sample's tag key is lowercase 'application' rather than 'Application'; the sample has one billing month, so each month is a series for month-over-month comparison.

Column adaptations (1)

ApplicationCharge period startCharge period end before

Application cost by service and month

Query results
Billing month	Service name	Total effective cost
2026-03	AmazonCloudWatch	$21.00
2026-03	Amazon API Gateway	$0.00
2026-03	AWS Lambda	$0.00

3 rows. Scroll inside the table to see more.

Default parameters use the precomputed result, generated as the read-only focus_reader role.

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select to_char(date_trunc('month', billing_period_start), 'YYYY-MM') as billing_month,
       service_name,
       sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where tags->>'application' = $1::text
  and charge_period_start >= $2::timestamptz
  and charge_period_end < $3::timestamptz
group by 1, 2
order by billing_month, total_effective_cost desc nulls last, service_name
limit 500

Parameters: $1 = application, $2 = period_start, $3 = period_end

Original FOCUS SQL

SELECT
  MONTH(BillingPeriodStart),
  ServiceName,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE Tags["Application"] = ?
  AND ChargePeriodStart >= ? AND ChargePeriodEnd < ?
GROUP BY
  MONTH(BillingPeriodStart),
  ServiceName

Billing month

Service name

Total effective cost

2026-03

AmazonCloudWatch

$21.00

2026-03

Amazon API Gateway

$0.00

2026-03

AWS Lambda

$0.00

select to_char(date_trunc('month', billing_period_start), 'YYYY-MM') as billing_month, service_name, sum(effective_cost) as total_effective_cost from focus.cost_and_usage where tags->>'application' = $1::text and charge_period_start >= $2::timestamptz and charge_period_end < $3::timestamptz group by 1, 2 order by billing_month, total_effective_cost desc nulls last, service_name limit 500

SELECT MONTH(BillingPeriodStart), ServiceName, SUM(EffectiveCost) AS TotalEffectiveCost FROM focus_data_table WHERE Tags["Application"] = ? AND ChargePeriodStart >= ? AND ChargePeriodEnd < ? GROUP BY MONTH(BillingPeriodStart), ServiceName