Chart controls and notes
Showing the first 20 categories. Open full screen to explore all 95 categories.
Analyze service costs month over month
Inspect the result, its parameters and the SQL behind it.
- Source
- FOCUS use-case library
- Data
- FOCUS 1.0 sample
- Status
- Runs on sample
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
- Source
- FOCUS 1.0 sample
- Result rows
- 95
- Status
- Runs on sample
- Execution
- Precomputed
- Result snapshot (UTC)
- 2026-10-11
Effective cost by service (March 2026)
95 rows. Scroll inside the table to see more.
Inspect Postgres SQL and original FOCUS SQL
Postgres SQL, as run
select date_trunc('month', charge_period_start at time zone 'UTC') as charge_month,
provider_name as provider_name,
service_name as service_name,
sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
and charge_period_start < $2::timestamptz
group by date_trunc('month', charge_period_start at time zone 'UTC'), provider_name, service_name
order by charge_month asc, total_effective_cost desc nulls last, provider_name asc nulls last, service_name asc nulls last
limit 500Original FOCUS SQL
SELECT MONTH(ChargePeriodStart), ProviderName, ServiceName, SUM(EffectiveCost) AS TotalEffectiveCost FROM focus_data_table WHERE ChargePeriodStart >= ? AND ChargePeriodStart < ? GROUP BY MONTH(ChargePeriodStart), ProviderName, ServiceName ORDER BY MONTH(ChargePeriodStart), SUM(EffectiveCost) DESC