FOCUSExplorer
Use cases
Read-only sample

FOCUS 1.0 billing data. Reference snapshots are dated on each page.

Compare billed cost per subaccount to budget

Product wants to confirm charges are in line with expectations (budgets) for a business which has all its cost within a single subaccount. The ChargePeriod is used for filtering to capture items that apply to the period only (excludes adjustments from previous periods that were applied in the current BillingPeriod).

← Budgeting
Source
FOCUS MCP snapshot
FOCUS editions
v1.0, v1.1, v1.2
Queries
1
Mode
Read-only
Library snapshot (UTC)
2026-10-08

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.

Subaccount billed usage cost

$1,430.99
Total billed cost
Query results
Provider nameSub account idSub account nameTotal billed cost
AWS11353890204Atlas Orion$1,430.99

1 row. Scroll inside the table to see more.

Precomputed result

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.

  • Provider Name
  • Sub Account ID
  • Sub Account Name
  • Billed Cost
  • Charge Category
  • Charge Period Start
  • Charge Period End
Read the source on focus.finops.org ↗