Cloudability Custom reports

Cloudability gives you the ability to create custom reports which provide insights into your cloud usage and spend. To access the Reports dashboard, navigate to Home > Reports .

From the Reports dashboard, you can:

You can also do the following with reports:

Report attributes

When you create or edit reports, you can configure the following report attributes:

Report name

A unique identifier for the report.

Time period

The time period from which the report displays data.

You can choose a second time period for comparison. Time Period Comparisons allow you to graph multiple time periods in a single report.

Category

Reports have a category to allow users to find the reports they are looking for more easily.

You can select an existing category using the drop-down or add a new category.

Cost data or utilization data

You can choose one of the following report types:

Cost Data : use these dimensions and metrics to display how you are spending money.

Utilization Data : use these dimensions and metrics to display how you are using assets.

Cost (termed Cost and Usage in the app) and Utilization Analytics are both powerful reporting tools to help you drill into your AWS data.

Analytic type

Description

Cost Analytics

Cost Analytics uses data from the Detailed Billing Reports files presenting accurate cost data based on what AWS bills you. It factors in any discounts or credits you receive, such as volume discounts or reserved instances.

Use Cost Analytics for all financial reporting where you need to see what you are spending.

Utilization Analytics

Utilization Analytics uses data from AWS Cloudwatch presenting instance-level details such as Average CPU utilization (percent), Bandwidth, and Disk I/O. Utilization analytics allow you to visualize overall elasticity, which helps you to decide if your instances require rightsizing or need to be turned off.

Use Utilization Analytics to determine utilization patterns for EC2 instances.

Tip:

In order for Utilization Analytics to access the AWS Cloudwatch data, you must add an IAM policy for each linked account.

Identity and Access Management (IAM)

Tip:

You should only use the cost metrics available in Utilization Analytics to analyze trends, and not financial reporting. This is because these metrics are calculated in Cloudability using on-demand rates, and cover only the compute portion of your bill, for example the billable instance hours but not bandwidth or storage.

Dimensions

A report can have between one and 10 dimensions.

Glossary of cost dimensions and metrics

Glossary of utilization dimensions and metrics

Metrics

Metrics are attributes that relate to a dimension and have an inbuilt aggregation method. For example, theInstance Type dimension can be associated with the Cost(Total) metric, which would display the total costs accumulated by each instance type.

A report can have between one and eight metrics.

There are multiple ways Cloudability can display your cost data. Each cost metric displays data calculated in different ways and is meant for specific use cases. Choosing the right metric is essential to understanding your cloud spending:

  • Cost (Total) is the most commonly used metric for your cloud spend analysis. It is reported on a cash flow-based accounting method, and for AWS, it is the Unblended Cost. If you need to allocate spending to resources, tags, or accounts, then the Unblended Rate used by this metric will give you the best results, including adjustments, for where AWS RIs were applied.
  • Cost (List) allows you to budget and forecast your cloud spend with a more consistent cost metric. Without reservations and custom pricing, budget and forecast work is made easier. Cost (List) supports AWS and GCP. For more information, see Using the Cost (List) metric for Budget and Forecasting .
  • Cost (Amortized) uses the Reserved Instance (RI) Amortization feature to give you the option to monitor the upfront costs of RI purchases using an accrual-based accounting method. This method spreads the signup fees of an RI on an hourly basis across the hours of the reservation term. For more information, see Why AWS Reserved Instance amortization matters and how to do it .

    Here is an example of amortizing a $12,000 upfront RI purchase:

    Month Cash-based Cost Accrual-based Cost
    June 2016 $12,000 $1,000
    July 2016 $0 $1,000
    August 2016 $0 $1,000
    September 2016 $0 $1,000
    October 2016 $0 $1,000
    November 2016 $0 $1,000
    December 2016 $0 $1,000
    January 2017 $0 $1,000
    February 2017 $0 $1,000
    March 2017 $0 $1,000
    April 2017 $0 $1,000
    May 2017 $0 $1,000
    Tip:

    This amortization example is simplified to make it easier to understand. Cloudability amortizes on an hourly basis, where a 1-year reservation equates to 8,760 reserved hours. So, a 30-day month like June amortizes out to $986, and a 31-day month like July is $1,019.

    For more information, see View and analyze data for your Reserved Instances .

  • Cost (Adjusted) takes custom pricing into account. The organizations that have custom pricing agreement with AWS can work with Cloudability to enable custom pricing to use Cost (Adjusted) which helps organizations understand the custom-priced cost at an individual service or transaction level.
  • Cost (Adjusted Amortized) is essentially Cost (Amortized) with custom pricing taken into account.
  • Cost (Total Blended) uses an AWS-specific blended rate and is on a cash basis, as opposed to an accrual basis like the Cost (Amortized) metric. You would use this metric for the following:
    • To reconcile to an AWS invoice.
    • To see the total amount of money you've committed to RIs in a given month.

Apart from these use cases, we recommend that you use Cost (Total) or Cost (Amortized) metrics.

Sort column

The column by which the report data is ordered.

Note:

When generating reports in Cloudability that exceed 10,000 records, sorting by Metric may lead to differences between the UI display and CSV export due to the way the data is processed. For more consistent results, especially for larger datasets, sorting by Dimension before exporting to CSV is recommended. A tooltip has been added to the Reporting UI to guide users on this process.

Display change

If you have chosen a time period for comparison, you can configure the report to display change over time either as the net change or as a percentage of the value for the earlier time period.

You can drill down into your comparison by Percent or Net change with the line items below. As with any standard Cost or Utilization report, you can filter these data points by the metrics and dimensions that interest you.

For more information on AWS Cost Analytics, check out these resources:

Glossary of Cloudability Dimensions and Metrics - Cost and Usage

Frequently used dimensions and metrics

Finding where your IT budget is going with AWS Cost Allocation Reports

Filters

Filtering enables you to only show results that match specific criteria. For example, you may want to only report on a specific tag value or type of cloud service.

To add a filter to the report:

  1. Select Add Filter
  2. Select the \Measure , Operator and Value from the drop-downs
  3. Select Submit .

Create a report

You can create a new report and configure the dimensions, metrics and filters from scratch.

  1. From the navigation pane, selectReports > New Report .
    The Create Report dialog is displayed.
  2. Configure the report attributes. Report attributes
  3. Select Save As .

The new report is saved.

Edit a report

If you have edit permissions for a report, you can make changes to an existing report.

  1. Open the report.
  2. Hover over the options below the report title, and select .

    The Edit Report dialog is displayed.

  3. Configure the report attributes.

    Report attributes .

  4. Select Save As .

The report is saved.

Duplicate a report

If you want to create a report that is largely similar to an existing report, you can copy an existing report and then make the changes you need. This allows you to keep the original report.

  1. Open the report you want to copy.
  2. Select Duplicate Report
    The Edit Report dialog is displayed. .
  3. Choose a new Report Name and configure any other report attributes you need.
    Report attributes .
  4. Select Save As .

A new report is saved using the name you have chosen. No changes have been made to the original report.

Add a category

You can create a new category.

  1. From the navigation pane, select Reports > New Report .
    TheCreate Report dialog is displayed.
  2. Configure the report attributes. Report attributes
  3. Select Add Category .
  4. Enter a category name in the New Category field.
  5. Select Submit .
  6. Select Save As .

The new category is saved.

.

Use case: Multi-line graphing

You are trying to identify why your AWS bill has changed. You use Cloudability 's multi-line graphing abilities to see how each line item changes over time.

  1. Click the check boxes next to each line in your report, then select Update to display the additional lines in the chart.
  2. You use multi-line graphing to split out tags, business units, linked accounts or everything else you pulled into your Cloudability AWS report.
  3. Finally, you click the Hide Aggregate link to see your selected line items in more detail by removing the top aggregate spend line.