Analyze Total Cost by Allocated Resource
Inspect the result, its parameters and the SQL behind it.
- Source
- FOCUS use-case library
- Data
- FOCUS 1.0 sample
- Status
- Not in v1.0 sample
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
- 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.
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