Chart controls and notes
The largest 7 series keep their own colors; the remaining series are combined as Other.
Forecast amortized costs month over month based on historical trends v1.3
Inspect the result, its parameters and the SQL behind it.
- Source
- FOCUS use-case library
- Data
- FOCUS 1.0 sample
- Status
- Adapted to v1.0
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
- Source
- FOCUS 1.0 sample
- Result rows
- 131
- Status
- Adapted to v1.0
- Execution
- Precomputed
- Result snapshot (UTC)
- 2026-10-11
Column adaptations (1)
Monthly effective cost by service category
Showing 100 of 131 rows. Scroll inside the table to see more.
Inspect Postgres SQL and original FOCUS SQL
Postgres SQL, as run
select date_trunc('month', billing_period_start) as billing_month,
case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
service_category,
service_name,
charge_category,
sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
and billing_period_end < $2::timestamptz
group by 1, 2, 3, 4, 5
order by billing_month, total_effective_cost desc nulls last, service_provider_name, service_category, service_name, charge_category
limit 500Original FOCUS SQL
SELECT MONTH(BillingPeriodStart), ServiceProviderName, ServiceCategory, ServiceName, ChargeCategory, SUM(EffectiveCost) AS TotalEffectiveCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? GROUP BY MONTH(BillingPeriodStart), ServiceProviderName, ServiceCategory, ServiceName, ChargeCategory