FOCUSExplorer
Use cases
Read-only sample

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

Calculate consumption of virtual currency within a billing period

Track virtual-currency burn throughout the billing period to forecast exhaustion dates and stay within budget.

← Budgeting
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.

Personas
FinOps Practitioner, Finance
Capabilities
Budgeting, Forecasting, Planning & Estimating, Reporting & Analytics

Calculate Consumption of Virtual Currency Within a Billing Period

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.

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

Original FOCUS SQL
SELECT 
    ProviderName,
    SUM(PricingCurrencyEffectiveCost) AS TotalPricingCurrencyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
AND PricingCurrency = ?
AND ChargeCategory = 'Usage'
GROUP BY
    ProviderName
ORDER BY TotalPricingCurrencyEffectiveCost DESC
LIMIT 10

Columns used

Column names from the source use case.

  • Provider Name
  • Pricing Currency Effective Cost
  • Charge Period Start
  • Charge Period End
  • Pricing Currency
  • Charge Category
Read the source on focus.finops.org ↗