Report effective cost of compute
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
Engineers and Engineering Managers want to reduce their billed cost for Compute from a specific provider. In order to do that, they need to know the current rate of commitment-based discounts (without contracted discounts) per type of commitment. This helps to strategize further purchases.
FOCUS SQL Query
SELECT
CommitmentDiscountType,
ProviderName,
ServiceName,
SubAccountId,
SubAccountName,
BillingPeriodStart,
SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd <= ?
AND ServiceCategory = 'Compute'
GROUP BY
CommitmentDiscountType,
ServiceName,
ProviderName,
SubAccountId,
SubAccountName,
BillingPeriodStart
FOCUS Datasets
FOCUS Columns
Related Capabilities
Related Personas
Related KPIs
Effective Average Compute Cost per Core
Track average cost, after amortization of unused commitment discounts, of each Core per calendar month.
Percent of Compute Spend Covered by Commitment Discounts
Measures the percentage of compute cost (excluding Spot) covered by commitment discount for the previous month.
Percentage of Commitment Discount Waste
The percentage of commitments not applied to on-demand spend.
Effective Savings Rate Percentage
Return on investment metric of all commitment discounts.