Analyze purchase of virtual currency
Analyze virtual-currency purchase patterns (e.g., upfront) and actively monitor burn down to prevent overage charges.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.3, v1.4
- Queries
- 2
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Analyze Purchase of Virtual Currency v1.3
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
The sample contains no virtual-currency Purchase charges: its only Purchase rows are three AWS Compute Savings Plan fees priced in Hours, so the PricingUnit filter has no virtual-currency unit to select.
Original FOCUS SQL
SELECT
ServiceProviderName,
PublisherName,
ChargeDescription,
PricingUnit,
BillingCurrency,
SUM(PricingQuantity) AS TotalPricingQuantity,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND ChargeCategory = 'Purchase'
AND PricingUnit = ?
GROUP BY
ServiceProviderName,
PublisherName,
ChargeDescription,
PricingUnit,
BillingCurrencyAnalyze Purchase of Virtual Currency v1.4
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
No virtual-currency Purchase charges are present in the sample: the only Purchase rows have PricingUnit Hours and describe AWS Compute Savings Plans.
Original FOCUS SQL
SELECT
ServiceProviderName,
ChargeDescription,
PricingUnit,
BillingCurrency,
SUM(PricingQuantity) AS TotalPricingQuantity,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND ChargeCategory = 'Purchase'
AND PricingUnit = ?
GROUP BY
ServiceProviderName,
ChargeDescription,
PricingUnit,
BillingCurrencyColumns used
Column names from the source use case.