Chart controls and notes
Showing the first 20 categories. Open full screen to explore all 37 categories.
Determine Effective Savings Rate by Service
This use cases focuses on Effective Savings Rate (ESR) per Service. The Effective Savings Rate is a KPI to track the efficiency of using commitment-based discounts. The KPI calculation is (Contracted Cost – Effective Cost) / Contracted Cost)
- 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 Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
Determine Effective Savings Rate by Service
Runs on sample- Source
- FOCUS 1.0 sample
- Result rows
- 37
- Status
- Runs on sample
- Execution
- Precomputed
- Result snapshot (UTC)
- 2026-10-11
Effective savings rate by service
37 rows. Scroll inside the table to see more.
Inspect Postgres SQL and original FOCUS SQL
Postgres SQL, as run
select provider_name as provider_name,
service_name as service_name,
sum(contracted_cost) as total_contracted_cost,
sum(effective_cost) as total_effective_cost,
(sum(contracted_cost) - sum(effective_cost)) / nullif(sum(contracted_cost), 0) as effective_discount_ratio
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
and charge_period_end < $2::timestamptz
group by provider_name, service_name
having abs(sum(contracted_cost)) >= 0.01
order by total_contracted_cost desc nulls last, provider_name, service_name
limit 500Original FOCUS SQL
SELECT ProviderName, ServiceName, SUM(ContractedCost) AS TotalContractedCost, SUM(EffectiveCost) AS TotalEffectiveCost, (SUM(ContractedCost) - SUM(EffectiveCost)) / NULLIF(SUM(ContractedCost), 0) AS EffectiveSavingsRate FROM focus_data_table WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ? GROUP BY ProviderName, ServiceName
Columns used
Column names from the source use case.