Aggregate effective cost by allocated resource ID to understand actual consumption costs for individual workloads or namespaces within shared infrastructure.
Column names from the source use case.
AllocatedMethodId, AllocatedResourceId and AllocatedResourceName (v1.3+ allocation columns) are absent from the v1.0 sample, so allocated-resource costs cannot be derived.
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