Modify Cost Intelligence Dashboard

Authors

• Alee Whitman, Commercial Architect (AWS)

Add Account Mapping Data

This section is optional and shows how you can add your Business Unit or Enterprise Account mapping data to your dashboard using Account Id as the identifier.

This example will show you how to replace the AccountID, with a name that is meaningful to your organization.

1. Create an account mapping file locally, you can use the sample here as a starting point: mapping_document.csv

2. In QuickSIght, select the summary_view Data Set

3. Select Edit data set

4. Select Add Data:

5. Select upload a file

6. Navigate to your mapping data file and click Open

7. Confirm the mappings are correct, click Next:

8. Select the two circles to open the Join configuration then select Left to change your join type:

9. Create following join clause then click Apply:

   • linked_account_id = (Your linked Account Id field name)

10. Scroll down in the field list, and confirm the new fields have the correct data types. The Account ID must be String:

11. Select Save

12. Repeat steps 2-11, creating mapping joins for your remaining QuickSight data sets:

    • s3_view
    • ec2_running_cost
    • compute_savings_plan_eligible_spend

13. Go to the Cost Intelligence Analysis

14. Edit the calculated field Account:

15. Change the formula from {linked_account_id} to {Account Name}

16. You can now select a visual, select the Account field, and you will see the account names in your visuals, instead of the Account number:

Customize your Summary View Cost value

This section is optional and shows how you can customize the analysis from using Amortized Cost to using Unblended/Invoiced Cost.

1. From the QuickSight Analysis dashboard, click on the Cost Intelligence Analysis

2. Edit the calculated field Cost:

3. Change the formula from {Cost_Amortized} to {Cost_Unblended}:

4. If you have usage with upfront charges - such as partial or full upfront Savings Plans or Reserved Instances, you will notice changes in the cost values of your dashboards.