Skip to main content

Wave – Report Filtering

How to Filter and Export Detailed Cost Reports in Wave

Written by Alphaus Support Team
Updated today

Overview

This guide walks you through the report filtering feature in Wave, which allows you to specify multiple conditions and download matching cost data as a CSV.

This feature is useful for cost analysis, identifying anomalies, and quickly checking specific costs you want to monitor. Since the output is in CSV format, it can also be integrated with BI tools or internal accounting systems.


Before You Begin

The report filter feature must be enabled in Ripple for the relevant Wave user.

  1. In Ripple, go to Wave User Management > Wave Feature Management

  2. Enable Wave Report Filters


Available Filter Options

  • Account

  • Product Code

  • Service Code

  • Region

  • Zone

  • Usage Type

  • Instance Type

  • Operation

  • Invoice

  • Description (Service description — more granular than the service name)

  • Resource

Multiple conditions can be combined to extract the data needed for analysis.


How to Create and Use Filters

This feature works by saving a filter first and then using it to download a CSV.

  1. Log in to Wave

  2. Click Report Filters in the left menu

  3. Select Create Filter in the top right corner

  4. Enter the filter conditions — make sure to select values before saving

    Notes

    • Adding multiple conditions within a filter applies them as AND conditions

    • Click Add filter to add an OR condition and broaden the output

  5. Once all conditions are set, click Save Filter in the bottom right corner

  6. Select the saved filter from Custom Filters, set the date range (billing month), click the CSV download icon, select the columns to include, and download the CSV


Filtering and Displaying Tags

To include tags in your filter:

  1. Select the tag key and tag value you want to include in the CSV output

  2. To include multiple tags, click Add filter and add them one by one

Notes Regex can be useful when you want to output values matching a specific pattern for a given tag key.

Match type options

Type

Description

Equals

Exact match

Contains

Contains the specified value

Starts with

Begins with the specified value

Ends with

Ends with the specified value

Does Not Equal

Does not match the specified value

Does Not Contain

Does not contain the specified value

How to output resources with no tags

  1. Specify the tag key

  2. Check the Regex checkbox

  3. Enter re:^\s*$ in the Regex field (the Type and Values fields are not required)

  4. Click + New Pair (and) and repeat steps 1–3 for each tag key

How to output all costs under a specific tag key

  1. Specify the tag key

  2. Check the Regex checkbox

  3. Enter re:[\S\s]+[\S]+ in the Regex field (the Type and Values fields are not required)

  4. Save, or repeat steps 1–3 if you want to specify additional tag keys


CSV Output

Notes If you are filtering by tag, check Daily Report when downloading.

  • Resources with no linked tags will still display all tag keys in the TAGS column (with empty values)

  • The TAGS column shows the tag key and value linked to each resource

Example:

user:Name: user:AWS: user:Env:prod user:Project:ripple

This means the row's usage is linked to tag key Env with value prod, and tag key Project with value ripple.


Important Notes

  • Usage hours display: Select Description when downloading if you want to include usage hours (Usage) in the output

  • AND condition behaviour: When multiple values are specified within the same AND condition, additional values are treated as OR conditions

    • Example: (Region A or B) AND (Service 1, 2, or 3) OR (Region A or B) AND (Service 8 or 9) AND (Resource A)

  • OR filter prefix matching: When multiple items are specified in an OR filter, prefix matching applies — for example, specifying AmazonS3 and AmazonEC2 will also match AmazonS3Glacier

  • Tag-based Billing Groups are not supported

  • Resource ID-level data output is available upon request — please contact Alphaus, as availability is limited due to data volume

  • Loading may take some time depending on the volume of data being extracted

  • If no account filter is specified, all accounts will be included in the output


Need More Help?

If any errors occur during the process or if you have any questions, please reach out to us:

Did this answer your question?