Forecast amortized costs month over month based on historical trends
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
Finance needs to perform month over month forecasting by extrapolating amortized costs based on historical rates. Having this data enables Finance to create amortized cost models.
FOCUS SQL Query
SELECT
MONTH(BillingPeriodStart),
ProviderName,
ServiceCategory,
ServiceName,
ChargeCategory,
SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
MONTH(BillingPeriodStart),
ProviderName,
ServiceCategory,
ServiceName,
ChargeCategoryFOCUS Datasets
FOCUS Columns
Related Capabilities
Related Personas
Related KPIs
Forecast Drift Rate
Evaluate how cloud infrastructure forecasts change over time due to various factors.
Forecast Accuracy Rate (Usage)
Compares forecasted vs. actual cloud usage (vCPUs, Memory, etc) over a specific period (e.g., day, month, quarter).
Forecast Accuracy Rate (Spend)
This metric compares forecasted vs. actual cloud spend over a specific period (e.g., day, month, quarter).