Update budgets for each application
FOCUS Versions
v1.3
v1.4
Context
Finance manages tracking of budgets and must update application budgets with the actual costs billed each month so the budget is not exceeded.
FOCUS SQL Query
SELECT
ServiceProviderName,
BillingPeriodStart,
BillingPeriodEnd,
Tags["Application"] AS Application,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
ServiceProviderName,
BillingPeriodStart,
BillingPeriodEnd,
Tags["Application"]