Identify anomalous daily spending by subaccount, region, and service

Context

It is important for FinOps Practitioners to track daily spend from various angles to ensure any anomalous cost trends are easily detected. Tracking by region and service enables further granularity in understanding the source of anomalous spend. Purchases can often cause false positives, for this reason, we want to monitor cost trends with up-front payments amortized. Graphing the data by day in a multiline chart can often help find the outliers.

FOCUS SQL Query

SELECT
  DATE(ChargePeriodStart) AS Day,
  ProviderName,
  SubAccountId,
  RegionId,
  RegionName,
  ServiceName,
  SUM(EffectiveCost) AS DailyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  DATE(ChargePeriodStart) AS StartDay,
  ProviderName,
  SubAccountId,
  RegionId,
  RegionName,
  ServiceName

FOCUS Datasets

Cost and Usage

FOCUS Columns

Provider Name Sub Account ID Service Name Charge Period Start Charge Period End Effective Cost Region ID Region Name

Anomaly Management

FinOps Practitioner

Anomaly-Detected Cost Avoidance Measures amount of cost avoidance as a result of identifying and correcting an anomaly.

Total Unpredicted Variance of Spend Measures the unpredicted variance of cost associated with CSP Cloud usage recorded over a given period of time.

Identify anomalous daily spending by subaccount, region, and service

FOCUS Versions

Context

FOCUS SQL Query

FOCUS Datasets

FOCUS Columns

Related Capabilities

Related Personas

Related KPIs