Data element filters

You can add a filter to a data element that limits the display to show only data that meets certain criteria. You create filters directly on a single data element. For a list of data elements see Intro to Data Elements. You can convert a data element filter into a control on a page. For more information see Intro to Control Elements.

Filter Types

A filter’s type dictates the type of user input values that will be accepted by the filter and the format in which those values are accepted. For example, a list filter provides a list of data values for users to choose from, while a range filter requests minimum and/or maximum values.

Built workbooks support seven filter types. The filter types you can choose from for each given filter are dependent on the type of column the filter targets.

JSON columns are the only column type that cannot be filtered. To filter on JSON data, first extract data from the JSON object. To begin extracting data, open the column's menu and select Extra columns.

Include Filters

Description: Selected values are included in your data. All other other values are excluded.

Input Type: List of selectable values

Column Types: Text, Numbers, Dates

Maximum Number of Values Displayed: 200

Sort Options: Descending by count (default), Ascending by count, Descending by alpha-numeric, Ascending by alpha-numeric

Note: Superficially, include and exclude filters look almost identical.

Exclude Filters

Description: Selected values are excluded in your data.

Input Type: List of selectable values

Column Types: Text, Numbers, Dates

Maximum Number of Values Displayed: 200

Sort Options: Descending by count (default), Ascending by count, Descending by alpha-numeric, Ascending by alpha-numeric

Make an existing Filter an Exclude Filter from the three dots menu.

Range (Number)

Description: Only values within the specified range are included in your data. The range is min/max inclusive.

Input Type: Min/Max numeric input boxes

Column Type: Numbers

Date Range

Description: Only values within the specified range are included in your data. The range is min/max inclusive. Both fixed and relative date types are supported.

Input Type: A single input box with the option to select fixed and/or relative dates for both min and max values.

Column Type: Dates

Text Match

Description: Search for full and partial matches between the input text and the data’s values.

Input Types:

  • A list of formulas to match on (such as Contains, Starts with, Ends with, Like), in addition to their value excluding counter parts (such as Does not contain, Does not start with, Does not end with, and Not like).

  • A text input box for search text.

  • A checkbox for selecting case sensitivity.

Column Type: Text

Boolean (true/false)

Description: Filters on true, false and null

Input Type: A list of values

Column Type: Logical (true/false)

Top N

For more details about using Top N see Top N Filter.

Description: Ranks and limits data in the column based on your specifications.

Input Type:

(1) A list of rank order/direction (e.g. First N)

(2) A numeric input for number of values to include

Column Types: Text, Numbers, Dates

Create a Filter

Before you start: This action is only available in edit mode. To begin editing, click Edit in the top right corner of the page.

1. Select the element you want to filter. From the vertical list on the side of the page or on a specific element on the page.
2. Hover over the column you would like to filter, and click its caret icon button.
3. Click Filter.

4. The new filter is added to the filter list and displayed in the filter popup above the element.

  • Existing filters can be accessed from filter ( ) button in the element's inline toolbar.

  • A filter type is auto-selected based on the column's type.
    Open the individual filter's three dot menu to change its type.

Keep Only or Exclude (Quick Filter)

Before you start: This action is only available in edit mode. To begin editing, click Edit in the top right corner of the page.

To quickly include or exclude a single value from a column's data, use the Keep only or Exclude options from the cell's right-click menu.

Example 1: Right click on a vertical bar chart's bar to open the cell context menu for the x-axis value represented by that bar. In the image below, clicking Keep only 2022-03 would filter the visualization to only show that one bar. Clicking Exclude 2022-03 would filter out the 2022-03 bar, leaving the other bars.

Example 2: Right click on a table or pivot table cell to open that cell's context menu. In the image below, clicking Keep only New Hampshire would filter the table to only show data rows with a cell value matching "New Hampshire" in the [Group Name] column. Clicking Exclude New Hampshire would filter out any row with a cell value matching "New Hampshire" in the [Group Name] column.

To Keep/Exclude multiple values at once, press Shift, select the cells you'd like to filter the table by, and right click on the cells to open the context menu. In the image below, clicking Keep only 3 values would filter the table to show only data rows with cell values matching "Commercial - Mackenzie Bank", "No Loans", and "New Hampshire" in the [Group Name] column. Clicking Exclude 3 values would filter out any row with a cell matching values.

Open & Edit an Existing Filter

1. If you have a full workbook page open, hover over the element and click the filter ( ) button in its inline toolbar.

Edit a Filter Type

Before you start: This action is only available in edit mode. To begin editing, click Edit in the top right corner of the page.

1. Click the element's filter ( ) button to open its filter popup open the filter popup.
2. Click the filter's more ( ) menu.
3. Select the new filter type.

Disable a Filter

1. Click the element's filter ( ) button to open its filter popup open the filter popup.
2. Click filter's switch toggle to disable or reenable a filter.