Compare resource usage month over month

FOCUS Versions

v1.3 v1.4

Context

FinOps Practitioners can compare usage and costs across charge periods to identify changes in usage month over month.

FOCUS SQL Query

SELECT 
  MONTH(ChargePeriodStart),
  ServiceProviderName,
  ServiceName,
  ResourceId,
  SkuId,
  ConsumedUnit,
  SUM(ConsumedQuantity) AS TotalConsumedQuantity
FROM focus_data_table
WHERE ChargeCategory='Usage'
  AND ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  MONTH(ChargePeriodStart),
  ServiceProviderName,
  ServiceName,
  ResourceId,
  SkuId,
  ConsumedUnit

FOCUS Datasets

Cost and Usage Contract Commitment Invoice Detail

FOCUS Columns

Charge Period Start Service Provider Name Service Name Resource ID SKU ID Consumed Unit Consumed Quantity Charge Category Charge Period End

Previous Analyze service costs by region Next Identify anomalous daily spending by subaccount