THE LINUX FOUNDATION PROJECTS
FOCUS Logo
See what is coming in v1.5 FOCUS 1.5
Docs navigation
On this page

    Identify anomalous daily spending by subaccount

    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

    It is important for FinOps Practitioners to track daily spend from various angles to ensure any anomalous cost trends are easily detected. 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,
  SUM(EffectiveCost) AS DailyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  DATE(ChargePeriodStart) AS StartDay,
  ProviderName,
  SubAccountId

    FOCUS Datasets

    Cost and Usage

    FOCUS Columns

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

    Related Capabilities

    Anomaly Management

    Related Personas

    FinOps Practitioner

    Related KPIs

    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.
    Previous Compare resource usage month over month Next Identify anomalous daily spending by subaccount and region