Chart controls and notes
Showing the first 20 categories. Open full screen to explore all 495 categories.
Update budgets for each application
Finance manages tracking of budgets and must update application budgets with the actual costs billed each month so the budget is not exceeded.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.3, v1.4
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Update budgets for each application v1.3
Adapted to v1.0- Source
- FOCUS 1.0 sample
- Result rows
- 500
- Status
- Adapted to v1.0
- Execution
- Precomputed
- Result snapshot (UTC)
- 2026-10-11
Column adaptations (2)
Billed cost by application
Showing 100 of 500 rows. Scroll inside the table to see more.
Inspect Postgres SQL and original FOCUS SQL
Postgres SQL, as run
select 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,
billing_period_start as billing_period_start,
billing_period_end as billing_period_end,
coalesce(tags->>'application', '(untagged)') as application,
sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
and billing_period_end < $2::timestamptz
group by 1, billing_period_start, billing_period_end, 4
order by abs(sum(billed_cost)) desc nulls last, application, service_provider_name
limit 500Original FOCUS SQL
SELECT ServiceProviderName, BillingPeriodStart, BillingPeriodEnd, Tags["Application"] AS Application, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? GROUP BY ServiceProviderName, BillingPeriodStart, BillingPeriodEnd, Tags["Application"]
Columns used
Column names from the source use case.