Calculate consumption of virtual currency within a billing period

FOCUS Versions

v1.3 v1.4

Context

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

FOCUS SQL Query

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

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail

FOCUS Columns

Service Provider Name Pricing Currency Effective Cost Charge Period Start Charge Period End Pricing Currency Charge Category

Previous Identify unused capacity reservations Next Compare billed cost per subaccount to budget