Analyze effective cost by pricing currency

Analyze effective cost by pricing 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 v1.0 sample lacks PricingCurrency and PricingCurrencyEffectiveCost, so BillingCurrency and EffectiveCost cannot reproduce pricing-denominated costs or exchange-rate effects.

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

Original FOCUS SQL

SELECT
    ServiceProviderName,
    HostProviderName,
    ServiceName,
    PricingCurrency,
    SUM(PricingCurrencyEffectiveCost) AS TotalPricingCurrencyEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
    ServiceProviderName,
    HostProviderName,
    ServiceName,
    PricingCurrency

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗