Compare billed cost per subaccount to budget

FOCUS Versions

v1.3 v1.4

Context

Product wants to confirm charges are in line with expectations (budgets) for a business which has all its cost within a single subaccount. The ChargePeriod is used for filtering to capture items that apply to the period only (excludes adjustments from previous periods that were applied in the current BillingPeriod).

FOCUS SQL Query

SELECT
  ServiceProviderName,
  SubAccountId,
  SubAccountName,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargeCategory = 'Usage'
  AND ChargePeriodStart >= ? and ChargePeriodEnd <= ?
  AND ServiceProviderName = ?  
  AND SubAccountId = ?  
GROUP BY
  ServiceProviderName,
  SubAccountId,
  SubAccountName

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail

FOCUS Columns

Service Provider Name Sub Account ID Sub Account Name Charge Category Charge Period Start Charge Period End

Previous Calculate consumption of virtual currency within a billing period Next Track contract commitment burn-down over time