Working with chart filters

Filters are an important feature that let you choose the information you want to include in your data analysis and display on the chart.

You can specify the following filters:

Filter by dimension of string or territory type

  1. Click the Add a filter button and choose the desired dimension of a string or territory type.
  2. Select the filter type:
    • Select
      1. Put ticks in front of the elements you want to display in the chart. Use the search tool if needed.
      2. By default, the selected items are included in the list. If you want to exclude the selected items and keep all the others, click the gear icon and select Exclude.
      3. Click Done.
    • Wildcard
      1. Select a type from the drop-down list.
      2. Enter a value in the String field.
      3. By default, the selected items are included in the list. If you want to exclude the selected items and keep all the others, click the gear icon and select Exclude.
      4. Click Done.
    • Ranking
      1. Select from the drop-down list which dimension elements you want to include — top or bottom.
      2. Enter the number of items.
      3. Select the measure to calculate and the type of aggregation.
      4. By default, the selected items are included in the list. If you want to exclude the selected items and keep all the others, click the gear icon and select Exclude.
      5. Click Done.

Filter by measure

  1. Click the Add a filter button and choose the desired measure and its aggregation type.
  2. Use the gear icon to manage the selection settings. Specify if you want to apply the filter to aggregated values or raw data.
  3. Select the desired filter type from the drop-down list.
  4. Enter the filter value in the bottom field.

Filter by date

Click the Add a filter button and choose the desired date dimension and the period for filtering.

The Date range option lets you specify a custom period of data filtering by setting up the start and end dates. The date range presets (e.g. this week or the previous quarter) are here to help you.

Another option is the Date - Index filtering. This is helpful If you want to get specific information like your staff performance for an exact month of the year for several years, or the sales of your product on Mondays:

Was this article helpful?
Thank you!
Is there anything we can improve? Message
We’re sorry to hear that
Please explain why this article wasn’t helpful to you. Message
Thank you for your feedback!
We’ll review your message and use it to help us improve your experience.
Rate this page
Rate this page
Is there anything we can improve?

Don’t want to answer

Thank you for your feedback!
Last updated: October 20, 2021

Found a typo or other text error? Select the text and press Ctrl+Enter.

Report a problem
We always review our content. Your feedback helps us improve it.
Provide an email so we can follow up
Thank you for your feedback!