Skip to main content

Dimensions, Group by, and Filters

Cloud Analytics provides a variety of billing dimensions, including custom, project, and system labels, to help you build a detailed view of your cloud spend.

Overview

If you're in the Edit mode of a report or when creating a new report from scratch, you can select the following chips to build the report:

  • + Add Dimension: Add fields along the X-axis (horizontal) of the chart.

  • + Add Grouping: Add fields along the Y-axis (vertical) of the chart. Note that when grouped by two or more dimensions, the report defaults to the Table view.

  • + Add Filter: Add filters to view specific information. For example, choose the standard dimension Cloud as a filter, and then specify the cloud provider of interest. See Filtering dimension values and Top/bottom results for more information.

A screenshot showing an empty Cloud Analytics report

Date/Time dimensions

When creating a new report, the Year, Month, and Day dimensions are added by default.

The Date/Time dimensions are connected with the report setting Time Interval.

Standard dimensions

  • Attribution: Choose one or more existing attributions to build your report.

  • Billing Account: This dimension refers to the Billing Account in the DoiT Platform Assets for Google Cloud; CloudHealth account ID and CloudHealth name for AWS.

  • Cloud: This reflects the cloud provider either Google Cloud or Amazon Web Services or both.

  • Cost Type: The Cost Type dimension helps to identify the type of charge covered for a specific billing item. For example, with AWS this helps to distinguish between RI fees, usage fees, saving plan fees, and taxes (if applicable).

  • Country, Region, Zone: These dimensions refer to the cloud location where resources are deployed. See Google Cloud Locations Regions & Zones and AWS Regions and Availability Zones.

  • Credit: A credit is usually a cloud provider's way of implementing discounts such as committed use discounts, sustained use discounts, or free-tier usage of a service.

  • Folder: Folder can contain projects, other folders, or a combination of both. For example, your organization might contain multiple departments, each with its own set of Google Cloud resources. Folders allow you to group these resources on a per-department basis.

  • GCP Marketplace (Google Cloud specific): This dimension helps to distinguish between services from Google Cloud Marketplace and Google Cloud itself.

  • Global Resource (Google Cloud specific): A globally unique Google Cloud service identifier for the resource that generated relevant usage. This dimension is based on the resource.global_name field in the Google Cloud Billing detailed usage cost data export.

    Note that not all resources have an identifier. Resources without Global Resource identifiers are shown as Global Resource N/A in Cloud Analytics reports. See also Identify granular cost data by service.

  • Operation (AWS specific): A specific AWS operation that generated relevant usage. For example, a value of RunInstances indicates the operation of an Amazon EC2 instance.

  • Project name (Google Cloud specific): A human-readable name for your Google Cloud project. See Identifying projects.

  • Project number (Google Cloud specific): An automatically generated unique identifier for your Google Cloud project. See Identifying projects.

  • Resource: An identifier of the resource that generated relevant usage. This dimension can be used to identify granular cost data by service in a report. Available for both AWS and Google Cloud.

  • Scope (Project/Account): This dimension refers to your AWS Account ID; whereas for Google Cloud it refers to the Project ID, which is a globally unique identifier for your Google Cloud project (see Identifying projects).

  • Service: The name or short description of the service that the usage is associated with. A service is the high-level type of cloud technology that can be broken down into SKUs.

  • Service ID: The identifier of the service that the usage is associated with.

  • SKU: A description of the resource type used by the service. A SKU is the resource itself for which there's a given Price Per Unit. See also prices for Google's cloud services and AWS Cloud Services Pricing.

  • SKU ID: The identifier of the resource used by the service. See also Google Cloud SKUs and AWS Cost and Usage Reports Product details: product/sku.

  • Unit: This dimension corresponds to the basic metric Usage. It varies by service but generally refers to their unit of measure. For example, Core hour; Ram gibibyte hour; EC2 vCPU-Hours.

Labels

Labels in DoiT Platform are key-value pairs that are used for identifying, organizing, and grouping resources to help tracking cloud spend. They can be either user-defined or generated by cloud providers or DoiT.

When creating reports in DoiT Console, you will see label dimensions in different categories:

  • Labels: Include AWS cost allocation tags and Google Cloud labels as assigned to resources.

  • Project Labels (Google Cloud specific): Labels set on the Google Cloud project level.

  • System Labels: Labels systematically generated by DoiT, AWS, and Google Cloud. Read more at System labels.

System labels

System Labels are systematically generated by DoiT, AWS, and Google Cloud. Usually you can tell which label is created by whom from the prefix of the label. For example, labels generated by DoiT starts with cmp, while labels generated by Google starts with compute.googleapis.com.

Below are the full lists of system labels generated by DoiT and Google Cloud. For the list of supported AWS cost allocation tags in the DoiT Platform, see AWS cost allocation tags.

Tip

For the sake of simplicity, once you selected a system label generated by DoiT or Google Cloud, it will automatically be replaced with a short name or alias. Note that due to the large amount of AWS labels, they will not be assigned any alias and will stay the same whether selected or not.

By DoiT

  • cmp/commitment_type (alias: CUD Type): Commitment types. Examples: General purpose N1 commitments, Compute-optimized C2 commitments.

  • cmp/compute_resource_name (alias: GCE Resource): Google Compute Engine resource names. Examples: CPU, memory, extended memory.

  • cmp/eligible_for_commitment (alias: CUD Eligible): Workloads eligible for committed use discounts (CUDs).

  • cmp/flexsave_eligibility: Flexsave eligibility of AWS workloads. See Flexsave coverage for its application in the preset report.

  • cmp/machine_type (alias: Machine Type): Machine types. Examples: C2 Compute-optimized, E2 General-purpose.

  • cmp/memory_to_core_ratio (alias: GB/CPU): The amount of memory (RAM) per CPU core.

By Google Cloud

  • compute.googleapis.com/cores (alias: Cores): The number of visible CPU cores.

  • compute.googleapis.com/memory (alias: Memory): The amount of memory (GB).

  • compute.googleapis.com/machine_spec (alias: Machine Spec): The machine types for your VMs.

  • compute.googleapis.com/is_unused_reservation (alias: Unused Reservation): Unused reservations.

GKE reports fields

For GKE dimensions and labels, see Understand GKE costs.

Example: Granular cost analytics on Google Cloud Run and Cloud Functions

The example report below shows how to combine the standard dimensions Service, Resource and SKU to identify granular cost data from Google Cloud Run instances and Cloud Function instances.

Cloud Analytics report for Cloud Run and Cloud Functions