Determine target of virtual currency usage

FOCUS Versions

v1.3 v1.4

Context

Identify and rank the top charge categories driving virtual-currency consumption to target optimization efforts.

FOCUS SQL Query

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

FOCUS Datasets

Contract Commitment Cost and Usage

FOCUS Columns

Service Provider Name Host Provider Name Service Name Charge Description Pricing Currency Effective Cost Charge Period Start Charge Period End Pricing Currency

Previous Analyze total cost by allocated resource Next Identify resources with shared cost allocation