Inspect the result, its parameters and the SQL behind it.
CapacityReservationId and CapacityReservationStatus are absent from the v1.0 sample, so compute charges cannot be classified by capacity-reservation usage.
SELECT
CASE
WHEN CapacityReservationId IS NOT NULL AND CapacityReservationStatus = 'Unused' THEN 'Unused Capacity Reservation'
WHEN CapacityReservationId IS NOT NULL AND CapacityReservationStatus = 'Used' THEN 'Compute using Capacity Reservation'
ELSE 'Compute without Capacity Reservation'
END AS Status,
ServiceProviderName,
BillingAccountId,
SUM(BilledCost) AS TotalBilledCost,
SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ?
AND ServiceCategory = 'Compute'
GROUP BY
ServiceProviderName,
BillingAccountId,
CapacityReservationId,
CapacityReservationStatus