Chart controls and notes
The largest 7 series keep their own colors; the remaining series are combined as Other.
Finance needs to perform month over month forecasting of cashflow by extrapolating from historical cash costs. Having this data enables Finance to create cashflow cost models.
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
Column names from the source use case.
The largest 7 series keep their own colors; the remaining series are combined as Other.
Showing 100 of 108 rows. Scroll inside the table to see more.
select date_trunc('month', billing_period_start at time zone 'UTC') as billing_month,
provider_name as provider_name,
service_category as service_category,
service_name as service_name,
sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
and billing_period_end < $2::timestamptz
group by 1, 2, 3, 4
order by billing_month, total_billed_cost desc nulls last, provider_name, service_category nulls last, service_name nulls last
limit 500SELECT MONTH(BillingPeriodStart), ProviderName, ServiceCategory, ServiceName, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? GROUP BY MONTH(BillingPeriodStart), ProviderName, ServiceCategory, ServiceName