This work is licensed under CC BY 4.0 - Read how use or adaptation requires attribution

Report costs by service category

Asset Library / FinOps Use Cases / Report costs by service category

Context

Understanding costs across providers, billing periods, and service categories (Analytics, Compute, Database, Storage, etc.) provides valuable insight into total costs.

FOCUS Columns

FOCUS SQL Query

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

Related KPIs
CSP Cloud Budget Burn Rate

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

Related Personas
FinOps Practitioner
Related Capabilities
Reporting & Analytics