Calculate consumption of virtual currency within a billing period v1.3
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
PricingCurrency and PricingCurrencyEffectiveCost are absent from the v1.0 sample, so consumption denominated in a virtual currency cannot be measured.
Original FOCUS SQL
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