3. Mass Filter

Applicable in: ❌Date Filter ✔️Facet Filter ✔️Hierarchy Filter ❌Alpha Numeric Filter

❌Numeric Filter

The Mass Filter option allows users to apply multiple filters simultaneously by copying and pasting values or performing bulk selections, making it ideal for managing large datasets efficiently.

Video 1: Mass Filter

How to Use Mass Filter

1

Locate and click the Copy-Paste Icon on the toolbar of the Super Filter visual.

2

If more than one category is used in the Category field, choose the category you want to filter. This will open a dedicated canvas for entering filter values for the category.

3

Use one of the following methods to enter values:

• Copy and Paste: Copy a list of values (e.g., from Excel or a text file) and paste them directly into the input field.

• Manual Input: Type values into the field, separating them by commas, new lines, or the specified delimiter.

4

Click the Apply button to activate the filter. The visual will automatically select and display the filtered values across your dataset.

5

To remove the input values, click the Erase button. This will clear all copy-pasted or typed entries, allowing you to reset the filter.

6

In the input canvas, click on the filter icon to exclude specific values. This will remove the entered values from the filter and select all other items instead.

Image 1: Category Selection for mass filter application.

Image 2: Mass Filter popup to enter values.

Ensure values match the format used in your dataset to avoid mismatches.

Customize Delimiters

1

In the Visualizations pane, navigate to the Format Visual settings.

2

Locate Delimiter option inside Bulk Copy Paste section in Toolbar.

3

Select a specific delimiter from the dropdown list. Available options are Comma, Carriage Return, Semicolon, Vertical Bar (|), Space.

Once the delimiter is chosen, it will automatically be applied to the Mass Filter input. Values entered using the selected delimiter will now be recognized accurately.

Image 3: Delimiter settings for Mass Filter in Format pane.

Placeholder Text

The Placeholder Text option allows users to set predefined text for the mass filter screen.

1

This option is available in the Bulk Copy-Paste section under the toolbar settings.

2

A text box is provided to edit and customize the placeholder text, which will appear in the Mass Filter pop-up box within the visual.

Image 4: Placeholder text settings in format pane.

Image 5: Mass Filter popup with placeholder text.

Click here to know more about real world use cases of using Mass Filter.

Close on Paste

The Close on Paste option allows users to automatically close the Bulk Copy-Paste window after pasting values and filters, streamlining the workflow and saving extra clicks.

1

This option is available in the Bulk Copy-Paste section under the toolbar settings.

2

When enabled, the Bulk Copy-Paste window will automatically close once the paste action is completed, allowing users to quickly return to their main workflow.