Determine target of virtual currency usage
Identify and rank the top charge categories driving virtual-currency consumption to target optimization efforts.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.2
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.
Determine Target of Virtual Currency Usage
Not in v1.0 sample- 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 (introduced in FOCUS v1.2) are absent from the v1.0 sample.
Original FOCUS SQL
SELECT
ProviderName,
PublisherName,
ServiceName,
ChargeDescription,
SUM(PricingCurrencyEffectiveCost) AS TotalPricingCurrencyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND PricingCurrency = ?
GROUP BY
ProviderName,
PublisherName,
ServiceName,
ChargeDescription
ORDER BY TotalPricingCurrencyEffectiveCost DESC
LIMIT 10Columns used
Column names from the source use case.