Dashboard: Cost and Usage Report: Cost by Account

This dashboard answers the following questions:

What is the total cost across all accounts?
What currency is used for cost calculations?
How has the cost trended monthly?
Which accounts incurred the highest costs?
What are the detailed costs by account?

This dashboard contains 2 cards, 1 input and 1 table.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/tailpipe-mod-aws-cost-usage-report-insights

Start the Powerpipe server:

powerpipe server

Open http://localhost:9033 in your browser and select Cost and Usage Report: Cost by Account dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run aws_cost_and_usage_insights.dashboard.cost_by_account_dashboard --share

Queries

This dashboard uses the the following queries:

select
  line_item_usage_account_id as "Account",
  round(sum(line_item_unblended_cost), 2) as "Total Cost"
from
  aws_cost_and_usage_report
where
  ('all' in ($1) or line_item_usage_account_id in $1)
group by
  line_item_usage_account_id
order by
  sum(line_item_unblended_cost) desc;

{
  "$1": "account_ids"
}

Dashboard: Cost and Usage Report: Cost by Account

Usage

Queries

Tags