How to create a text-type dashboard filter [v11]

Version: Yurbi v11
Role: Agent and higher
Permission: Agent with view permission to the dashboard

A dashboard filter is your personal tool for focusing on the data that matters most to you. It is like having a magnifying glass for your reports, allowing you to highlight specific areas of interest.

Imagine you only want to see data from a specific time period, like This Month, or perhaps from particular locations. A dashboard filter can narrow down your report to show only those relevant details

You have the freedom to either use pre-saved filters or craft your own to perfectly suit your needs. These custom filters can be saved as views for easy access in the future.

In this guide, we'll focus on crafting text-based filters, the most popular type amongst users. These filters are often used to segment data based on text values such as locations, customer names, product names, etc.

All images shown are just an example. Names, fields, and values will be dependent on the organization and the user logged-in

Let us dive right into the process of setting up a text filter:

Click on New Filter, located in the filter bar region of your dashboard

Type in your desired Filter Name.

Leave the Filter Type as Text.

The system will display the fields available to filter as per your selected Filter Type.

The Filter Index will be filled in automatically.

This represents the order of your filters. Each new filter will increment this number. If you want to re-order your filter, you should change this value. 
This represents the order of your filters. Each new filter will increment this number. If you want to re-order your filter, you should change this value. 

By default, Smart Filter is turned off.

Here is a more in-depth article on Smart Filter

Under Selected Filtered Field, click Show for each widget listed

Check the field this filter should apply to.  A single filter can only apply to 1 field per report.    

Each box represents a report on the dashboard. As an agent with view permission, you cannot control what fields are shown.
Each box represents a report on the dashboard. As an agent with view permission, you cannot control what fields are shown.

TIP: Ideally, you'll want to tick the same box for every field. But no worries if a checkbox field doesn't appear! Your dashboard data will remain consistent and accurate.

In the Criteria Builder section, click Create.

Criteria Builder is where you set the conditions for your filter.
Criteria Builder is where you set the conditions for your filter.

For Logical Filter, the default setting is AND.

For Conditional, the default setting is IS.    

In a Text Filter Type, under Operator, you can choose among EQUAL, IN LIST, or LIKE. Here is how they differ:

TEXT FILTER: EQUAL

EQUAL: This provides a single-select or dropdown list filter.

By default, a filter dropdown can only display 250 items. If your source data contains more than this, instead of a dropdown, the filter will automatically convert into a textbox.

This number can be increased by the server admin.

Under Equal to, you can select a default value for the filter, or leave it blank by choosing Custom Values.

Later on, if you want to choose a default value, click Show Values

On the Operator option, leaving these fields blank allows the user to choose their desired value for filtering on the dashboard.
On the Operator option, leaving these fields blank allows the user to choose their desired value for filtering on the dashboard.

 By default, the Enable Get Values List is checked

Click Add to Table.

Finally, click Save.

To activate your filters, click on the star icon corresponding to your chosen filter.
To activate your filters, click on the star icon corresponding to your chosen filter.

For an EQUAL filter, this will be the filter interface shown in the dashboard.

TEXT FILTER: IN LIST

IN LIST: This provides a checkbox filter.

Under In List you can leave it blank or choose your desired value

On the Operator option, leaving these fields blank allows the user to choose their desired value for filtering on the dashboard.  
On the Operator option, leaving these fields blank allows the user to choose their desired value for filtering on the dashboard.  

By default, the Enable Get Values List is checked

Click Add to Table.

Finally, click Save.

To activate your filters, click on the star icon corresponding to your chosen filter.
To activate your filters, click on the star icon corresponding to your chosen filter.

For an IN LIST filter, this will be the filter interface shown in the dashboard.

TEXT FILTER: LIKE

LIKE: This provides a search filter.

Under Like you can leave it blank

On the Operator option, leaving these fields blank allows the user to choose their desired value for filtering on the dashboard.  
On the Operator option, leaving these fields blank allows the user to choose their desired value for filtering on the dashboard.  

By default, the Enable Get Values List is checked

Click Add to Table.

Finally, click Save.

To activate your filters, click on the star icon corresponding to your chosen filter.
To activate your filters, click on the star icon corresponding to your chosen filter.

For a LIKE filter, this will be the filter interface shown in the dashboard.

TIP: When using a search box filter, you can use % when entering a value

Entering a value without % will only return values starting with the one you entered

Entering a value with % at the start will return values that have it anywhere in the phrase

Note: Depending on the configuration of your data source, this could be case-sensitive.  gtx may not bring back fields that match GTX if your underlying database is set to be case-sensitive

Remember to save each time you make changes, either to overwrite or save as a new one.

And there you have it! You now know how to create text filters for your dashboard!

Was this article helpful?

How to create a new dashboard filter [v11]
How to delete a widget [v11]