Analyze effective cost by pricing currency

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

FOCUS Versions

v1.2

Context

Break down the effective cost by each pricing currency to surface regional price differences and exchange-rate impacts.

FOCUS SQL Query

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