Analyze effective cost by pricing currency

FOCUS Versions

v1.3 v1.4

Context

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

FOCUS SQL Query

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

FOCUS Datasets

Contract Commitment Cost and Usage Billing Period Invoice Detail

FOCUS Columns

Service Provider Name Host Provider Name Service Name Pricing Currency Pricing Currency Effective Cost Billing Period Start Billing Period End

Previous Analyze cost by participating entities Next Analyze purchase of virtual currency