Determine Effective Savings Rate
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
FOCUS Versions
v1.0
v1.1
v1.2
Context
The Effective Savings Rate (ESR) is a KPI to track the efficiency of using commitment discounts.
The KPI calculation is (Contracted Cost – Effective Cost) / Contracted Cost.
Outcome: FinOps Practitioners are able to compute the ESR, which is (Contracted Cost – Effective Cost) / Contracted Cost.
FOCUS SQL Query
SELECT
SUM(ContractedCost) AS ContractedCost,
SUM(EffectiveCost) AS EffectiveCost,
(SUM(ContractedCost) - SUM(EffectiveCost)) / NULLIF(SUM(ContractedCost), 0) AS EffectiveSavingsRate
FROM focus_data_table
WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ?