Chart controls and notes
Showing the first 20 categories. Open full screen to explore all 61 categories.
While Finance will look at higher-level forecasting data such as amortized costs and total cashflow, a FinOps Practitioner needs to forecast costs from quantities of priced units and effective costs based on historical rates. Effective costs are used to account for the costs of commitment purchases. This query extracts cost and usage data by Region and Service. More fine-grain extrapolation could be done based on further dimensions like Tags.
Column names from the source use case.
Showing the first 20 categories. Open full screen to explore all 61 categories.
Showing 100 of 500 rows. Scroll inside the table to see more.
select 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,
billing_period_start,
billing_period_end,
service_category,
service_name,
region_id,
region_name,
pricing_unit,
sum(effective_cost) as total_effective_cost,
sum(pricing_quantity) as total_pricing_quantity,
sum(effective_cost) / nullif(sum(pricing_quantity), 0) as effective_unit_rate
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
and billing_period_end <= $2::timestamptz
group by 1, 2, 3, 4, 5, 6, 7, 8
order by total_effective_cost desc nulls last, service_provider_name, service_name, region_id, pricing_unit
limit 500SELECT ServiceProviderName, BillingPeriodStart, BillingPeriodEnd, ServiceCategory, ServiceName, RegionId, RegionName, PricingUnit, SUM(EffectiveCost) AS TotalEffectiveCost, SUM(PricingQuantity) AS TotalPricingQuantity FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd <= ? GROUP BY ServiceProviderName, BillingPeriodStart, BillingPeriodEnd, ServiceCategory, ServiceName, RegionId, RegionName, PricingUnit