Filtering the data that you want to view - AWS Billing and Cost Management
Combining filters to show data in commonFilters and logical operations (AND/OR)Filter and group options

Filtering the data that you want to view

With Cost Explorer, you can filter how you view your AWS costs by one or more of the following values:

  • API operation

  • Availability Zone (AZ)

  • Billing Entity

  • Charge Types

  • Include All

  • Instance Type

  • Legal Entity

  • Linked Account

  • Platform

  • Purchase Option

  • Region

  • Service

  • Tag

  • Tenancy

  • Usage Type

  • Usage Type Group

You can use Cost Explorer to see which service you use the most, which Availability Zone (AZ) most of your traffic is in, which linked account uses AWS the most, and more. You can also apply multiple filters to look at intersecting datasets. For example, you can use the Linked Account and Services filters to identify the linked account that spent the most money on Amazon EC2.

To filter your data

  1. Open Cost Explorer.

  2. For Filters, choose a value. After you make a selection, a new control appears with additional options.

  3. In the new control, select the items from each list that you want to display in the chart or begin typing in the search box to have Cost Explorer autocomplete your selection. After you choose your filters, choose Apply filters.

    Note

    Each time that you apply filters to your costs, Cost Explorer creates a new chart. However, you can use your browser's bookmark feature to save configuration settings for repeated use. Forecasts aren't saved, and Cost Explorer displays the most recent forecast when you revisit your saved chart.

You can continue refining your cost analysis by using multiple filters, by grouping your data by filter type, and by using the options in the Advanced Options tab.

Combining filters to show data in common

Cost Explorer displays a chart that represents the data in common to the filters that you have selected, which means that you can use filters together to analyze subsets of cost data. For example, if you set the Service filter to show costs related to Amazon EC2 and Amazon RDS services and then select Reserved using the Purchase Option filter, the cost chart shows how much money Reserved instances on Amazon EC2 and Amazon RDS cost for each of the three months specified.

Note

  • AWS Cost and Usage report in Cost Explorer is limited to 1024 filters.

  • The RI Utilization reports allow filtering by only one service at a time, and only for the following services:

    • Amazon EC2

    • Amazon Redshift

    • Amazon RDS

    • ElastiCache

    • Amazon ES

Filters and logical operations (AND/OR)

When you select multiple filters, and values for each filter, Cost Explorer applies rules that emulate the logical AND and OR operators to your selections. Within each filter, Cost Explorer emulates the logical OR filter to your selection of filter types. In other words, the chart it displays adds the aggregate costs for each item together. Using the previous example, you see bars for both of the selected services, Amazon EC2 and Amazon RDS.

When you select multiple filters, Cost Explorer applies the logical AND operator to your selections. In other words, if you use the Services filter and specify Amazon EC2 and Amazon RDS costs for inclusion and then also apply the Purchase Options filter to select a single type of purchase option, you see only the Non-Reserved charges incurred by Amazon EC2 and Amazon RDS.

Filter and group options

In Cost Explorer, you can filter by the following groups:

  • API Operation

    Requests made to and tasks performed by a service, such as write and get requests to Amazon S3.

  • Availability Zone

    Distinct locations within a region that are insulated from failures in other AZs. They provide inexpensive, low-latency network connectivity to other AZs in the same region.

  • Billing Entity

    The organization that bills the customer for a service. For AWS service charges, AWS is the billing entity. For third-party services sold through AWS Marketplace, AWS Marketplace is the billing entity.

  • Instance Type

    The type of RI that you specified when you launched an Amazon EC2 host, Amazon RDS instance class, Amazon Redshift node, or Amazon ElastiCache node. The instance type determines the hardware of the computer used to host your instance.

  • Legal Entity

    The provider of your AWS services. For AWS service charges, AWS is the legal entity. For AWS service charges in India, AISPL is the legal entity.

  • Linked Account

    The member accounts in an organization. For more information, see Consolidated billing for AWS Organizations.

  • Platform

    The operating system that your RI runs on. Platform is either Linux or Windows.

  • Purchase Option

    The method you choose to pay for your Amazon EC2 instances, including Reserved Instances, Spot Instances, Scheduled Reserved Instances, and On-Demand Instances.

  • Region

    The geographic areas where AWS hosts your resources.

  • Resources

    The unique identifier for your resources.

    Note

    To enable resource granularity, opt-in through on the Cost Explorer settings page as the payer account. This is available for Amazon EC2 instances.

  • Service

    AWS products. To learn what's available, see AWS Products and Services. You can use this dimension to filter costs by specific AWS Marketplace software, including your costs for AMIs, web services, and desktop apps. See the What is AWS Marketplace? guide for more information.

    Note

    The RI Utilization reports allow filtering by only one service at a time, and only for the following services:

    Amazon EC2, Amazon Redshift, Amazon RDS, ElastiCache

  • Tag

    Label that you can use to track costs associated with specific areas/entities within your business. For more information about working with tags, see Applying User-Defined Cost Allocation Tags.

  • Tenancy

    Specifies if the Amazon EC2 instance is hosted on shared or single-tenant hardware. Some tenancy values include Shared (Default), Dedicated, Host.

  • Usage Type

    Usage types are the units that each service uses to measure the usage of a specific type of resource. For example, the BoxUsage:t2.micro(Hrs) usage type filters by the running hours of Amazon EC2 t2.micro instances.

  • Usage Type Group

    Usage type groups are filters that collect a specific category of usage type filters into one filter. For example, BoxUsage:c1.medium(Hrs), BoxUsage:m3.xlarge(Hrs), and BoxUsage:t1.micro(Hrs) are all filters for Amazon EC2 instance running hours, so they are collected into the EC2: Running Hours filter.

    Usage type groups are available for Amazon EC2, DynamoDB, and Amazon S3. The specific groups available to your account depend on what services you've used. The list of groups that might be available includes but isn't limited to the following:

    • DDB: Data Transfer - Internet (In)

      Filters by costs associated with how many GB are transferred to your DynamoDB databases.

    • DDB: Data Transfer - Internet (Out)

      Filters by costs associated with how many GB are transferred from your DynamoDB databases.

    • DDB: Indexed Data Storage

      Filters by costs associated with how many GB that you have stored in DynamoDB.

    • DDB: Provisioned Throughput Capacity - Read

      Filters by costs associated with how many units of read capacity that your DynamoDB databases used.

    • DDB: Provisioned Throughput Capacity - Write

      Filters by costs associated with how many units of write capacity that your DynamoDB databases used.

    • EC2: CloudWatch - Alarms

      Filters by costs associated with how many CloudWatch alarms that you have.

    • EC2: CloudWatch - Metrics

      Filters by costs associated with how many CloudWatch metrics that you have.

    • EC2: CloudWatch - Requests

      Filters by costs associated with how many CloudWatch requests that you make.

    • EC2: Data Transfer - CloudFront (Out)

      Filters by costs associated with how many GB are transferred from your Amazon EC2 instances to a CloudFront distribution.

    • EC2: Data Transfer - CloudFront (In)

      Filters by costs associated with how many GB are transferred to your Amazon EC2 instances from a CloudFront distribution.

    • EC2: Data Transfer - Inter AZ

      Filters by costs associated with how many GB are transferred into, out of, or between your Amazon EC2 instances in different AZs.

    • EC2: Data Transfer - Internet (In)

      Filters by costs associated with how many GB are transferred to your Amazon EC2 instances from outside the AWS network.

    • EC2: Data Transfer - Internet (Out)

      Filters by costs associated with how many GB are transferred from an Amazon EC2 instance to a host outside the AWS network.

    • EC2: Data Transfer - Region to Region (In)

      Filters by costs associated with how many GB are transferred to your Amazon EC2 instances from a different AWS Region.

    • EC2: Data Transfer - Region to Region (Out)

      Filters by costs associated with how many GB are transferred from your Amazon EC2 instances to a different AWS Region.

    • EC2: EBS - I/O Requests

      Filters by costs associated with how many I/O requests that you make to your Amazon EBS volumes.

    • EC2: EBS - Magnetic

      Filters by costs associated with how many GB that you have stored on Amazon EBS Magnetic volumes.

    • EC2: EBS - Provisioned IOPS

      Filters by costs associated with how many IOPS-months that you have provisioned for Amazon EBS.

    • EC2: EBS - SSD(gp2)

      Filters by costs associated with how many GB per month of General Purpose storage that your Amazon EBS volumes use.

    • EC2: EBS - SSD(io1)

      Filters by costs associated with how many GB per month of Provisioned IOPS SSD storage that your Amazon EBS volumes use.

    • EC2: EBS - Snapshots

      Filters by costs associated with how many GB per month that your Amazon EBS snapshots store.

    • EC2: EBS - Optimized

      Filters by costs associated with how many MB per instance hour that your Amazon EBS-optimized instances use.

    • EC2: ELB - Running Hours

      Filters by costs associated with how many hours that your Elastic Load Balancing load balancers ran.

    • EC2: Elastic IP - Additional Address

      Filters by costs associated with how many Elastic IP addresses that you have attached to running Amazon EC2 instances.

    • EC2: Elastic IP - Idle Address

      Filters by costs associated with Elastic IP addresses that you have that are not attached to running Amazon EC2 instances.

    • EC2: NAT Gateway - Data Processed

      Filters by costs associated with how many GB that your network address translation gateways (NAT gateways) processed.

    • EC2: NAT Gateway - Running Hours

      Filters by costs associated with how many hours that your NAT gateways ran.

    • EC2: Running Hours

      Filters by costs associated with how many hours that your Amazon EC2 instances ran.

      This Usage Type Group contains only the following Usage Types:

      • AlwaysOnUsage

      • BoxUsage

      • DedicatedUsage

      • HighUsage

      • HostBoxUsage

      • HostUsage

      • ReservedHostUsage

      • SchedUsage

      • SpotUsage

      • UnusedBox

    • ElastiCache: Running Hours

      Filters by costs associated with how many hours that your Amazon ElastiCache nodes ran.

    • ElastiCache: Storage

      Filters by costs associated with how many GB that you have stored in Amazon ElastiCache.

    • RDS: Running Hours

      Filters by costs associated with how many hours that your Amazon RDS databases ran.

      This Usage Type Group contains only the following Usage Types:

      • AlwaysOnUsage

      • BoxUsage

      • DedicatedUsage

      • HighUsage

      • InstanceUsage

      • MirrorUsage

      • Multi-AZUsage

      • SpotUsage

    • RDS: Data Transfer – CloudFront – In

      Filters by costs associated with how many GB are transferred into Amazon RDS from a CloudFront distribution.

    • RDS: Data Transfer – CloudFront – Out

      Filters by costs associated with how many GB are transferred from a CloudFront distribution to Amazon RDS data transfers.

    • RDS: Data Transfer – Direct Connect Locations – In

      Filters by costs associated with how many GB are transferred into Amazon RDS through a Direct Connect network connection.

    • RDS: Data Transfer – Direct Connect Locations – Out

      Filters by costs associated with how many GB are transferred from Amazon RDS through a Direct Connect network connection.

    • RDS: Data Transfer – InterAZ

      Filters by costs associated with how many GB are transferred into, out of, or between Amazon RDS buckets in different AZs.

    • RDS: Data Transfer – Internet – In

      Filters by costs associated with how many GB are transferred to your Amazon RDS databases.

    • RDS: Data Transfer – Internet – Out

      Filters by costs associated with how many GB are transferred from your Amazon RDS databases.

    • RDS: Data Transfer – Region to Region – In

      Filters by costs associated with how many GB are transferred to your Amazon RDS instances from a different AWS Region.

    • RDS: Data Transfer – Region to Region – Out

      Filters by costs associated with how many GB are transferred from your Amazon RDS instances to a different AWS Region.

    • RDS: I/O Requests

      Filters by costs associated with how many I/O requests that you make to your Amazon RDS instance.

    • RDS: Provisioned IOPS

      Filters by costs associated with how many IOPS-months that you have provisioned for Amazon RDS.

    • RDS: Storage

      Filters by costs associated with how many GB that you have stored in Amazon RDS.

    • Redshift: DataScanned

      Filters by costs associated with how many GB that your Amazon Redshift nodes scanned.

    • Redshift: Running Hours

      Filters by costs associated with how many hours that your Amazon Redshift nodes ran.

    • S3: API Requests - Standard

      Filters by costs associated with GET and all other standard storage Amazon S3 requests.

    • S3: Data Transfer - CloudFront (In)

      Filters by costs associated with how many GB are transferred into Amazon S3 from a CloudFront distribution.

    • S3: Data Transfer - CloudFront (Out)

      Filters by costs associated with how many GB are transferred from a CloudFront distribution to Amazon S3 data transfers, such as how much data was uploaded from your Amazon S3 bucket to your CloudFront distribution.

    • S3: Data Transfer - Inter AZ

      Filters by costs associated with how many GB are transferred into, out of, or between Amazon S3 buckets in different AZs.

    • S3: Data Transfer - Internet (In)

      Filters by costs associated with how many GB are transferred to an Amazon S3 bucket from outside the AWS network.

    • S3: Data Transfer - Internet (Out)

      Filters by costs associated with how many GB are transferred from an Amazon S3 bucket to a host outside the AWS network.

    • S3: Data Transfer - Region to Region (In)

      Filters by costs associated with how many GB are transferred to Amazon S3 from a different AWS Region.

    • S3: Data Transfer - Region to Region (Out)

      Filters by costs associated with how many GB are transferred from Amazon S3 to a different AWS Region.

    • S3: Storage - Standard

      Filters by costs associated with how many GB that you have stored in Amazon S3.

  • Charge Type

    Charge types are different types of charges or fees.

    Credit

    Any AWS credits that are applied to your account.

    Other out-of-cycle charges

    Any subscription charges that aren't upfront reservation charges or support charges.

    Recurring reservation fee

    Any recurring charges to your account. When you purchase a Partial Upfront or No Upfront Reserved Instance from AWS, you pay a recurring charge in exchange for a lower rate for using the instance. The recurring fees can result in spikes on the first day of every month, when AWS charges your account.

    Refund

    Any refunds that you received. Refunds are listed as a separate line item in the data table. They do not appear as an item in the chart because they represent a negative value in the calculation of your costs. The chart displays only positive values.

    Reservation applied usage

    Usage that AWS applied reservation discounts to.

    Support fee

    Any charges that AWS charges you for a support plan. When you purchase a support plan from AWS, you pay a monthly charge in exchange for service support. The monthly fees can result in spikes on the first day of every month, when AWS charges your account.

    Tax

    Any taxes that are associated with the charges or fees in your cost chart. Cost Explorer adds all taxes together as a single component of your costs. If you select five or fewer filters, Cost Explorer displays your tax expenses as a single bar. If you select six or more filters, Cost Explorer displays five bars, stacks, or lines, and then aggregates all remaining items, including taxes, into a sixth bar, stack slice, or plot line that is labeled Other.

    If you choose to omit RI upfront fees, RI recurring charges, or Support charges from your chart, Cost Explorer continues to include any taxes that are associated with the charges.

    Cost Explorer displays your tax costs in the chart only when you choose Monthly drop down. When you filter your cost chart, the following rules govern the inclusion of taxes:

    1. Taxes are excluded if you select non-Linked Account filters, either singly or in combination with other filters.

    2. Taxes are included if you select the Linked Accounts filters.

    Upfront reservation fee

    Any upfront fees that are charged to your account. When you purchase an All Upfront or Partial Upfront Reserved Instance from AWS, you pay an upfront fee in exchange for a lower rate for using the instance. The upfront fees can result in spikes in the chart for the days or months when you make your purchases.

    Usage

    Usage that AWS didn't apply reservation discounts to.