Analyze purchase of virtual currency

This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.

Personas: Finance, FinOps Practitioner, Procurement
Capabilities: Allocation, Budgeting, Forecasting, Invoicing & Chargeback, Planning & Estimating, Reporting & Analytics

Analyze Purchase of Virtual Currency

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 exist in the sample: the only Purchase rows have PricingUnit Hours and are AWS Savings Plan purchases.

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

Original FOCUS SQL

SELECT
    ProviderName,
    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
    ProviderName,
    PublisherName,
    ChargeDescription,
    PricingUnit,
    BillingCurrency

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗