Report costs by service category and subcategory

FOCUS Versions

v1.3 v1.4

Context

Understanding costs across service providers, billing periods, and service categories (Analytics, Compute, Database, Storage, etc.) and service subcategories (Virtual Machines, Relational Databases, Content Delivery, etc) provides valuable insight into total costs.

FOCUS SQL Query

SELECT
  ServiceProviderName,
  BillingCurrency,
  BillingPeriodStart,
  ServiceCategory,
  ServiceSubcategory,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? and BillingPeriodEnd  < ?
GROUP BY
  ServiceProviderName,
  BillingCurrency,
  BillingPeriodStart,
  ServiceCategory,
  ServiceSubcategory
ORDER BY TotalBilledCost DESC

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail Billing Period

FOCUS Columns

Service Provider Name Billing Currency Billing Period Start Service Category Service Subcategory Billed Cost Billing Period End

FinOps Practitioner

Previous Report costs by service category Next Report on initial contract commitments