FOCUSExplorer
Use cases
Read-only sample

FOCUS 1.0 billing data. Reference snapshots are dated on each page.

Analyze purchase of virtual currency

Analyze virtual-currency purchase patterns (e.g., upfront) and actively monitor burn down to prevent overage charges.

← Allocation
Source
FOCUS MCP snapshot
FOCUS editions
v1.2
Queries
1
Mode
Read-only
Library snapshot (UTC)
2026-10-08

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.

  • Provider Name
  • Publisher Name
  • Charge Description
  • Pricing Unit
  • Billing Currency
  • Pricing Quantity
  • Billed Cost
  • Charge Period Start
  • Charge Period End
  • Charge Category
Read the source on focus.finops.org ↗