Compare billed cost per subaccount to budget

This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.

Personas: Product
Capabilities: Budgeting
KPIs: Percentage Variance of Budgeted vs. Actual CSP Cloud Spend, CSP Cloud Budget Burn Rate

Compare billed cost per subaccount to budget

Runs on sample

Source: FOCUS 1.0 sample
Result rows: 1
Status: Runs on sample
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Totals billed usage cost for a selected provider and subaccount within the charge period; the default selects AWS subaccount Atlas Orion in March 2026 (USD). The source query supplies actual spend for comparison with an external budget and does not calculate a budget variance.

Charge period startCharge period endProviderSubaccount

Subaccount billed usage cost

$1,430.99

Total billed cost

Query results
Provider name	Sub account id	Sub account name	Total billed cost
AWS	11353890204	Atlas Orion	$1,430.99

1 row. 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 provider_name as provider_name,
       sub_account_id as sub_account_id,
       sub_account_name as sub_account_name,
       sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where charge_category = 'Usage'
  and charge_period_start >= $1::timestamptz
  and charge_period_end <= $2::timestamptz
  and provider_name = $3::text
  and sub_account_id = $4::text
group by provider_name, sub_account_id, sub_account_name
order by provider_name, sub_account_id, sub_account_name nulls last
limit 500

Parameters: $1 = period_start, $2 = period_end, $3 = provider_name, $4 = sub_account_id

Original FOCUS SQL

SELECT
  ProviderName,
  SubAccountId,
  SubAccountName,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargeCategory = 'Usage'
  AND ChargePeriodStart >= ? and ChargePeriodEnd <= ?
  AND ProviderName = ?  
  AND SubAccountId = ?  
GROUP BY
  ProviderName,
  SubAccountId,
  SubAccountName

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗