Report costs by service category
FOCUS Versions
v1.3
v1.4
Context
Understanding costs across service providers, billing periods, and service categories (Analytics, Compute, Database, Storage, etc.) provides valuable insight into total costs.
FOCUS SQL Query
SELECT
ServiceProviderName,
BillingCurrency,
BillingPeriodStart,
ServiceCategory,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? and BillingPeriodEnd < ?
GROUP BY
ServiceProviderName,
BillingCurrency,
BillingPeriodStart,
ServiceCategory
ORDER BY TotalBilledCost DESC