Analyze Total Cost by Allocated Resource

Source: FOCUS use-case SQL
Status: Not in v1.0 sample
Results: Not run
Mode: Read-only
Library snapshot (UTC): 2026-10-08

AllocatedMethodId, AllocatedResourceId and AllocatedResourceName (v1.3+ allocation columns) are absent from the v1.0 sample, so allocated-resource costs cannot be derived.

Review the original SQL below and the required columns before using a newer FOCUS dataset.

Original FOCUS SQL

SELECT
  AllocatedResourceId,
  AllocatedResourceName,
  ResourceId AS OriginResourceId,
  SUM(EffectiveCost) AS TotalEffectiveCost,
  COUNT(*) AS ChargeCount
 FROM focus_data_table
 WHERE ChargeCategory='Usage'
  AND ChargePeriodStart >= ? AND ChargePeriodEnd <= ?
  AND AllocatedMethodId IS NOT NULL
  AND AllocatedResourceId IS NOT NULL
 GROUP BY
  AllocatedResourceId,
  AllocatedResourceName,
  ResourceId
 ORDER BY TotalEffectiveCost DESC