Chart controls and notes
Showing the first 20 categories. Open full screen to explore all 35 categories.
The largest 7 series keep their own colors; the remaining series are combined as Other.
It is good practice for Engineering to monitor cost and usage of services by availability zone for all regions to ensure: there isn’t any cost/usage occurring outside of the expected locations your costs are spread according to an expected ratio
Column names from the source use case.
Showing the first 20 categories. Open full screen to explore all 35 categories.
The largest 7 series keep their own colors; the remaining series are combined as Other.
64 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,
region_name,
availability_zone,
billing_period_start,
sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where sub_account_id = $1::text
and charge_period_start >= $2::timestamptz
and charge_period_end < $3::timestamptz
group by 1, 2, 3, 4
order by total_effective_cost desc nulls last, service_provider_name, region_name, availability_zone, billing_period_start
limit 500SELECT ServiceProviderName, RegionName, AvailabilityZone, BillingPeriodStart, SUM(EffectiveCost) AS TotalEffectiveCost FROM focus_data_table WHERE SubAccountId = ? AND ChargePeriodStart >= ? AND ChargePeriodEnd < ? GROUP BY ServiceProviderName, RegionName, AvailabilityZone, BillingPeriodStart ORDER BY ServiceProviderName, RegionName, AvailabilityZone, BillingPeriodStart