Report application cost month over month
FOCUS Versions
v1.0
v1.1
v1.2
v1.3
v1.4
Context
As an application owner or engineering team I want to track the month over month costs of my application.
FOCUS SQL Query
SELECT
MONTH(BillingPeriodStart),
ServiceName,
SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE Tags["Application"] = ?
AND ChargePeriodStart >= ? AND ChargePeriodEnd < ?
GROUP BY
MONTH(BillingPeriodStart),
ServiceName