Adding Filters on a Report

Filter components let readers choose what data they want to analyse.

Filters work on both kinds of tile in PersivX — those created with drag and drop, and those created with custom queries.

Filter components available in PersivX:

  • Single select dropdown
  • Multi select dropdown
  • Search bar
  • Date filter
  • Single select list
  • Multi select list

Filter components are fully customizable, in both functionality and look and feel. They can also be configured to update only selected visuals, which is covered separately in Filter Settings.

The filter component types available in PersivX

Creating a Filter on the Report

Step 1: Create a Tile

Click and drag in an empty area of the canvas to create a new tile. A tile is where a filter is created.

Creating a new tile for a filter component

Step 2: Choose the Filter Type

Change the tile type to a Filter Component and select the kind of filter you want. Dropdown, date, search bar, and list are all built the same way.

Choosing a filter component type

Step 3: Pick the Attribute to Filter On

Select one attribute (column) from any object (table) for readers to filter on. In this example we let them filter on the customer's country using a dropdown. The component is built as soon as the attribute lands in the Filter On box. Ignore Show Label From for now.

Adding an attribute to the Filter On box

Step 4: Style the Component

The UI updates according to the filter type you chose, letting you customize the component. Use the visual styling options to match your report's styling. Some filters also let you set a default value, applied automatically when the report loads.

A styled filter component
ℹ️ The Same Styling Tools as Any Visual Style the tile with Tile UI, add a title and subtitle under Title, Subtitle & Disclaimer, and change the filter component itself under Visual Styling.
Filter component styling options

Using the Filter

Once the filter is added, readers can filter the data on the report.

A reader applying a filter on the report
⚠️ If a Visual Errors When Filters Are Applied Check that the object (table) the filter is built on has a relationship to at least one of the objects used in the visual. Without it, PersivX cannot build the correct query and throws an error.
ℹ️ Excluding a Visual From a Filter If a filter should not affect a particular visual, open Filter Settings for that visual and uncheck Use Filter.