Compare billed cost per subaccount to budget

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

Provider name

Sub account id

Sub account name

Total billed cost

AWS

11353890204

Atlas Orion

$1,430.99

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

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