Analyze service costs by subaccount

Personas: Engineering
Capabilities: Reporting & Analytics, Usage Optimization
KPIs: Power Schedule Adherence Rate, Percentage Resource Utilization, Percentage of Legacy Resource, Percent Storage on Frequent Access Tier, Percent of Unused Resources, Auto-scaling Efficiency Rate, Number of Monthly Active Users (MAU) for Cost Insight Products, Percentage of Normalized, Queryable Data within Repository

Analyze service costs by subaccount

Runs on sample

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

Top 10 service-by-charge-period effective costs for one subaccount. The default is a Microsoft subscription, whose charge periods are daily (AWS ones are hourly).

Subaccount IDCharge period startCharge period end before

Top service costs for subaccount

Query results
Charge period start	Sub account id	Sub account name	Service name	Total effective cost
2026-03-09	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	Virtual Machines	$36.21
2026-03-04	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	Azure SQL Database	$33.00
2026-03-18	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	Azure SQL Database	$31.50
2026-03-16	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	SQL Database	$29.18
2026-03-12	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	Azure SQL Database	$28.50
2026-03-18	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	SQL Database	$27.00
2026-03-02	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	Virtual Machines	$9.88
2026-03-14	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	Virtual Machines	$9.81
2026-03-04	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	Virtual Machines	$9.60
2026-03-05	/subscriptions/1caaa5a3-2b66-438e-8ab4-bce37d518c5d	Horizon Eclipse	Azure SQL Database	$8.50

10 rows. 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 charge_period_start,
       sub_account_id,
       sub_account_name,
       service_name,
       sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where sub_account_id = $1::text
  and charge_period_start >= $2::timestamptz
  and charge_period_end < $3::timestamptz
group by 1, 2, 3, 4
order by total_effective_cost desc nulls last, charge_period_start, service_name
limit 10

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

Original FOCUS SQL

SELECT
  ChargePeriodStart,
  SubAccountId,
  SubAccountName,
  ServiceName,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE SubAccountID = ?
  AND ChargePeriodStart >= ? AND ChargePeriodEnd < ?
GROUP BY
  ChargePeriodStart,
  SubAccountId,
  SubAccountName,
  ServiceName
ORDER BY SUM(EffectiveCost) DESC
LIMIT 10

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗