Compare billed cost per subaccount to budget

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
  ProviderName,
  SubAccountId,
  SubAccountName,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargeCategory = 'Usage'
  AND ChargePeriodStart >= ? and ChargePeriodEnd <= ?
  AND ProviderName = ?  
  AND SubAccountId = ?  
GROUP BY
  ProviderName,
  SubAccountId,
  SubAccountName

FOCUS Datasets

Cost and Usage Invoice Detail

FOCUS Columns

Provider Name Sub Account ID Sub Account Name Billed Cost Charge Category Charge Period Start Charge Period End

Budgeting

Product

Percentage Variance of Budgeted vs. Actual CSP Cloud Spend Measure the variance or difference between estimated or budgeted costs for using public cloud services & the actual costs incurred.

CSP Cloud Budget Burn Rate The rate at which an organization is consuming or spending its allocated budget for cloud services from a CSP.

Compare billed cost per subaccount to budget

FOCUS Versions

Context

FOCUS SQL Query

FOCUS Datasets

FOCUS Columns

Related Capabilities

Related Personas

Related KPIs