Cost and Usage Report: Cost by AccountCost and Usage Report: Cost by RegionCost and Usage Report: Cost by ServiceCost and Usage Report: Cost by TagCost and Usage Report: Overview
Dashboard: Cost and Usage Report: Cost by Region
This dashboard answers the following questions:
- What is the total cost across all regions?
- What currency is used for cost calculations?
- How has the regional cost trended monthly?
- What are the top 10 most expensive regions?
- What are the detailed costs by account and region?
This dashboard contains 3 cards, 1 input and 1 table.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/tailpipe-mod-aws-cost-usage-report-insightsStart the Powerpipe server:
powerpipe serverOpen http://localhost:9033 in your browser and select Cost and Usage Report: Cost by Region dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run aws_cost_and_usage_insights.dashboard.cost_by_region_dashboard --shareQueries
This dashboard uses the the following queries:
select strftime(date_trunc('month', line_item_usage_start_date), '%b %Y') as "Month", coalesce(product_region_code, 'global') as "Region", round(sum(line_item_unblended_cost), 2) as "Total Cost"from aws_cost_and_usage_reportwhere ('all' in ($1) or line_item_usage_account_id in $1)group by date_trunc('month', line_item_usage_start_date), coalesce(product_region_code, 'global')order by date_trunc('month', line_item_usage_start_date), sum(line_item_unblended_cost) desc;
{ "$1": "account_ids"}