Working with Google Data Studio Filter [Guide]

By Zekeriya Mulbay

Filters refine or reduce the data in your reports. By this, you can focus on the data that is most relevant to your needs.

šŸ’” You can apply a filter to a chart, control, page, or the entire report using the DATA properties tab.

There are 2 types of filters:

  • Include filters retrieve only the records that match the conditions.
  • Exclude filters retrieve only the records that DON'T match the conditions.

šŸ’” Filters do not change your raw data, they just change the view scope.

Filter conditions and operators are clauses which help you construct complicated filters with logic. Here are list of conditions and operators: link

šŸ’” You can apply filters to dimensions or metrics, or both.

Filter Control let viewers apply filters and set parameter values. Date is one of the most popular filters and you check about this here.

Controls let viewers manipulate the data shown in a Data Studio report in the following ways:

  • Viewers can filter the data by specific dimension values.
  • Viewers set the time frame of the report.
  • Viewers can set parameter values that can then be used in calculated fields or passed back to the connector.
  • Viewers can change the underlying data set used by a data source.

How to add a control to a report

  1. Edit your report.
  2. In the toolbar, select Add a control.
  3. Select the control type, then position on the page.
  4. On the right, use the options in the properties panel to configure the control.
  5. To filter the report by selected dimension values, use a dimension for the Control field.
  6. To set the value of a parameter, use that parameter as the Control field.

Here is an example for adding a control field with country selection;

Types of controls

The controls menus are divided into 2 sections:

The controls in the first section can be used to filter data, or to set parameter values. The controls in the second section perform specialized functions and can't be used to set parameter values.

Drop-down list and Fixed-size lists

These controls show the viewer a list of options from which they can select. The list can come from the values in a dimension, or from a list of acceptable values defined for a parameter.

Input box

Input boxes let the viewer enter a value. When used as a filter, you configure how the control matches the user's input against the dimension values. When used as input to a parameter, the input box can accept any value, values from a list, or a range of values.

Advanced filter

Advanced filters are similar to input boxes, but they can only be used as filters. Advanced filters can't set parameter values.

Slider

Slider controls let viewers filter by a range of values in a numeric dimension, or select a single value from a numeric parameter.

Checkbox

Checkbox controls let viewers filter by a Boolean dimension or set the value of a Boolean parameter.

Date range control

The date range control is a customizable calendar widget that enables your viewers to change the time frame of a report.

Data control

The data control lets viewers change the underlying data set to which a data source connects. This makes it easy for you to share reports with viewers who want to use that report with their own data. Using a data control can eliminate the need to create a separate report for each customer or consumer.

Adding a filter to a group

  1. Select reports which will have the same filter
  2. Click on the right mouse button ā†’ "Group"
  3. On the right menu, navigate to the "Filter" section
  4. Click +Add a filter

Click CREATE NEW FILTER.

You can also reuse an existing filter

  1. Name the filter.
  2. Select Include or Exclude. Include filters include only data that matches the expression you provide. Exclude filters remove all data that matches the expression.
  3. Select the dimension or metric by which to filter.
  4. Select the comparison operator (e.g. Equals, Contains, Greater than, **etc.**).
  5. Provide a comparison value for the expression.
  6. (Optional) To add an OR clause, click OR on the right of the condition.
  7. (Optional) To add an AND clause, click AND below the clause.
  8. Click SAVE.

Adding a filter to the entire report

  1. Select File ā†’ Report Settings
  2. On the right menu, navigate to the "Filter" section
  3. Click +Add a filter

Click CREATE NEW FILTER.

You can also reuse an existing filter

  1. Name the filter.
  2. Select Include or Exclude. Include filters include only data that matches the expression you provide. Exclude filters remove all data that matches the expression.
  3. Select the dimension or metric by which to filter.
  4. Select the comparison operator (e.g. Equals, Contains, Greater than, **etc.**).
  5. Provide a comparison value for the expression.
  6. (Optional) To add an OR clause, click OR on the right of the condition.
  7. (Optional) To add an AND clause, click AND below the clause.
  8. Click SAVE.

Adding a filter to a page

  1. Select **Page ā†’ Current Page Settings ****menu
  2. Select DATA tab
  3. On the right menu, navigate to the "Filter" section
  4. Click +Add a filter

Click CREATE NEW FILTER.

You can also reuse an existing filter

  1. Name the filter.
  2. Select Include or Exclude. Include filters include only data that matches the expression you provide. Exclude filters remove all data that matches the expression.
  3. Select the dimension or metric by which to filter.
  4. Select the comparison operator (e.g. Equals, Contains, Greater than, **etc.**).
  5. Provide a comparison value for the expression.
  6. (Optional) To add an OR clause, click OR on the right of the condition.
  7. (Optional) To add an AND clause, click AND below the clause.
  8. Click SAVE.

How to add a filter to a chart?

  1. Edit your report.
  2. Select the chart or control you want to filter. You can also filter a group of charts and/or controls.
  3. Select the DATA tab in the Properties panel.
  4. Click +Add a filter.

Click CREATE NEW FILTER.

You can also reuse an existing filter

  1. Name the filter.
  2. Select Include or Exclude. Include filters include only data that matches the expression you provide. Exclude filters remove all data that matches the expression.
  3. Select the dimension or metric by which to filter.
  4. Select the comparison operator (e.g. Equals, Contains, Greater than, **etc.**).
  5. Provide a comparison value for the expression.
  6. (Optional) To add an OR clause, click OR on the right of the condition.
  7. (Optional) To add an AND clause, click AND below the clause.
  8. Click SAVE.

Here we are adding a filter to reduce the scope of the countries into only United States OR India.


Spread the word

Keep reading