BIlling Dashboards from Cost and Usage report

Question & Answer
,
1

Hello All,

I am having challenges in creating billing dashboards in QuickSIght. I have moved cost and usage report (CUR) into QuickSIght which has all the billing information in my account following the steps in the link below.

The dashboards I want to create are;

  1. Daily cost of EC2 for the last 6 months
  2. Commutative total cost of all AWS services for the past 6 months.

Please help!

Thanks,
John

2

Hi @johnaws - Welcome to AWS QuickSight and thanks for posting the question. Can you please follow the below blog for setting up CUR.

Note -

  1. The CUR contains lots of additional information apart from your requirement. You can always create, filter the data.

Please check this out, hope the above details will help you.

Regards - Sanjeeb

3

Hi @johnaws

The data to answer those two questions is there - and its most likely available exactly or similar via one of the pre-existing dashboards.

For example - to look at daily EC2 cost for 6 months (cudos has 7 months) you could via a simple modification, edit standard CUDOS dashboard to display this data. An alternative is to create a new dashboard and blog shared by @Sanjeeb2022 will help. but it requires understanding the datasets a bit.

If you choose to modify standard CUDOS, here are some high level steps.

1- Save As on cudos Dashboard to analysis in order to edit. DOCS
2-Once in the analysis- go to the COMPUTE sheet, the first chart shows monthly ec2 cost and usage. Replace billing date with usage date and aggregation level from month to daily. edit or delete other charts to fit your needs.
3- change filter to 6 months instead of 7.
4- publish as your custom dashboard.

Regards,
Ramon

1 Like
4

Thanks All ! very helpful.

5

Hi @johnaws. Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!