Skip to main content

Edit reports

You can edit a report if you are its owner or have the Editor permission.

Overview

There are multiple types of changes you can make to a report. Depending on the nature of the change, you may need to rerun the report.

Real-time updates

Changes that don't alter the results themselves will be reflected in the report instantly. This includes changes made to:

  • Metric by which your dimensions are being measured
  • Chart type (visualization)
  • Sorting of results
  • ML features: Trend Analysis, Forecasting

Changes requiring rerun

Changes that require you to rerun the report include:

  • Adding additional dimensions
  • Modifying the time interval/range
  • Filtering dimensions
  • Filtering metrics

In the following sections we're going to explain the usage of common report settings.

Metric

CMP supports two categories of metrics: basic metrics and custom metrics.

Basic metrics include:

  • Cost: Analyze your reports on a basis of how much your selected dimensions cost you.

  • Usage: Analyze your reports and selected dimensions on a usage basis. Make sure to pair this with the Unit chip as a Breakdown Dimension.

  • Savings: Analyze your reports and selected dimensions on a savings basis. These savings come as a result of your commercial agreement with Google Cloud and the agreed-upon discount between your company and DoiT International.

note

The discount is not available for: Google Maps APIs, Google Support, Looker, Preemptible VMs (compute engine), third-party GCP Marketplace services, or Premium OS Images.

info

For using filters on metrics, see Metric Filters and Top/bottom results.

Aggregation

Use aggregations to summarize how you view your reports.

ML Features

Perform advanced analysis in your reports, including:

Time Interval and Time Range

Specify the frequency in which data is aggregated.

  • Time Interval: Choose from Hour, Day, Week, Month, Quarter, and Year.

  • Time Range: Choose a pre-defined time range or define your own custom range.

Exclude partial Intervals

When looking at a report, the most current interval is always incomplete. For example, if the report is Daily then the current day will always be collecting billing data throughout the day.

Selecting the Exclude partial Intervals checkbox will remove any incomplete time interval from the data of the report, which means the Analytics will hide data for the current day for daily intervals, current week for monthly intervals, etc.

This option is convenient when performing comparative reports, for example, Month over Month analysis, or Week over Week analysis. It can also help to improve the accuracy of the heatmap views by removing outliers, as partial intervals tend to skew trends by representing incomplete periods.

Promotional credits

Promotional credits, including migration credits, commitment related credits, vendor program credits, and others, are applied to monthly invoices. By default, they are not included in the reports.

For reports with Time interval set to Month or greater, you can select the Include promotional credits checkbox to list them in the report, thus to have a more transparent view of the cost breakdown.

View as

This is where you select how your report is visualized. For example, you can choose to view your report as Table, Heatmap, Column Chart, Bar Chart, Treemap, Stacked Area, and other visualizations.

View data as (Comparative report)

The Compare Data dropdown will automatically add either % change or actual difference between two time intervals in a report.

To view a comparative report:

  1. Enter the Edit mode of the report.

  2. Select an option from the View data as dropdown list:

  3. When being prompted, select Show report to allow CMP to make adjustments necessary to enable the Comparative Report mode.

  4. Once enabled, you will see new columns in your table based view showing the Δ between time intervals. This difference (Δ) appears after the intervals compared.

    In the example below, there are new columns in the report showing the Percentage Change (Δ%) between time intervals. The percentage change between months 04 (April) and 05 (May) is shown in the column 05 Δ%.

Currency

Currency that the billing data is reported in (Metric must be Cost).

Filtering dimension values

To view a subset of a dimension's values:

  1. Select the chip of the dimension of interest

  2. Configure the filter.

    There are two additional options:

    • Exclude selection: To exclude a selection of values.
    • Advanced: To filter services using regular expressions.
  3. Select Save.

  4. Re-run the report to apply the filters you've configured.

info

Dimension chips with and without configured filters are shown in different colors.

You can use the Expand button (|<) in the lower-right corner of the report page to display the configured filters.

Top/bottom results

When performing analysis, it is often helpful to hide values below or above certain thresholds.

The Top/bottom results option allows you to limit the number of results for fields displayed along the Y-axis (vertical) of the chart (the Group by dimensions).

  1. Select the + Add Filter chip.

  2. Select Top/bottom results.

  3. Specify the filter settings, including:

    • Limit to: Top or Bottom results.
    • Number: The number of results to display.
    • Metric: The metric by which the field is measured.