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 by extrapolating amortized costs based on historical rates. Having this data enables Finance to create amortized cost models.
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 131 rows. Scroll inside the table to see more.
select date_trunc('month', billing_period_start) as billing_month,
case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
service_category,
service_name,
charge_category,
sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
and billing_period_end < $2::timestamptz
group by 1, 2, 3, 4, 5
order by billing_month, total_effective_cost desc nulls last, service_provider_name, service_category, service_name, charge_category
limit 500SELECT MONTH(BillingPeriodStart), ServiceProviderName, ServiceCategory, ServiceName, ChargeCategory, SUM(EffectiveCost) AS TotalEffectiveCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? GROUP BY MONTH(BillingPeriodStart), ServiceProviderName, ServiceCategory, ServiceName, ChargeCategory