Calculate consumption of virtual currency within a billing period

Source

FOCUS use-case SQL

Status

Not in v1.0 sample

Results

Not run

Mode

Read-only

Library snapshot (UTC)

2026-10-08

PricingCurrency and PricingCurrencyEffectiveCost are absent from the v1.0 sample, so consumption denominated in a virtual currency cannot be measured.

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

SELECT 
    ServiceProviderName,
    SUM(PricingCurrencyEffectiveCost) AS TotalPricingCurrencyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
AND PricingCurrency = ?
AND ChargeCategory = 'Usage'
GROUP BY
    ServiceProviderName
ORDER BY TotalPricingCurrencyEffectiveCost DESC
LIMIT 10