Click Filter Your Dashboard in the dashboard’s right panel (if it’s your first filter), or + if you are adding another filter. The Add Filter dialog box is displayed.
(Optional) If you have multiple data sources, select the data source that contains the fields you want to filter. Filters applied to fields from one data source do not affect fields from another data source even on the same dashboard.
Select the field by which to filter.
Select the type of filter from the pane on the left, such as List, Criteria, Calendar or Ranking. The options provided in this window may vary according to the selected field type (Date, Numeric or Descriptive).
Select the required filtering details in the panel on the right to create one of the following types of filters:
Creating an Include/Exclude Filter
Creating a Text/Numeric/Date Filter
Creating a Top/Bottom Ranking Filter
Creating a Calendar Filter
These are explained in depth below. 6. Click the Star Favorite button to save this filter. You can give your starred filter a unique name by clicking in the text field and editing the given name. This will be useful when you need to quickly add a new filter (with same field type) or update a filter to reflect the unique parameters that you defined in your starred filter.
Your favorite filters are visible to shared users.
Click OK to filter the data in the Dashboard and add this filter to the Filters panel on the right of the Dashboard. After a filter has been added to the Dashboard, it stays displayed on the Dashboard’s Filters panel. Any changes that you make to the filter are immediately reflected in the Dashboard.
You can rearrange the filters in the Filters panel by dragging a filter above or below another filter.
For a short video overview of dashboard filters, see below.
Creating an Include/Exclude Filter (List Filter)
This type of filter enables you to define whether selected field values are included or excluded. To define a List filter:
Select/clear the field values to be included/excluded in the Dashboard.
Click OK to filter the data in the Dashboard and add a List filter to the Filter panel of the Dashboard.
Selecting Single Selection or Multi Selection
By default, list filters are set to multi-selection. To toggle between single and multi-selection, click the button on the upper right of the list filter: Multi Selection:
Creating a Text Filter
This type of filter enables you to filter according to text matching. Text filters are case insensitive for all data sources by default.
Text filters are case insensitive for all data sources by default. This cannot be changed. However, if you are connected to a Snowflake data source, you can configure Sisense so that your queries are either case sensitive or case insensitive.
To do so:
From the Admin tab, click System Configuration.
At the top of the screen, click Configuration. The System Configuration screen displays.
In the Configuration screen, click the Sisense logo five times. The Advanced System Configuration screen displays.
In the main menu on the left, click Translation.
Scroll down to TextFilterCaseSensitive and click it to expand the section.
To set all queries of Snowflake data sources to:
Case sensitive, enable this setting
Case insensitive, disable this setting
For a short video overview of adding a text filter to your dashboard, see below:
For Sisense for Linux, Aggregated Time Level filtering (hour/minute) was supported until L8.2.6 SP3 but was removed temporarily. The lowest granularity for Time Level filtering is by Day.
Click OK to filter the data in the Dashboard and add a date filter to the Filter panel of the Dashboard.
Advanced Filtering Criteria
If you require advanced filtering options that are not included in the provided settings (for dashboard or widget), you can add or edit filters in the Advanced section.
To add or edit filtering criteria:
Click Advanced in the left panel.
Add or edit filtering criteria. Click Test to see the results of your new/edited filter.
Click OK to add the filter.
Example 1 – Adding an OR statement
The example below shows an OR statement being used to display multiple names. After clicking Test, the matches are displayed to the right of the script.
Examples using JAQL Queries Example 2 – Filtering by Measures
This option lets you filter dimensions by measures, returning only the filtered members and associated values.
In this example, all products with a total price equal or greater than 1 million will be returned.
Results include the relevant product names and price, for example:
Product A, 1000000
Product B, 1551246
Example 3 – Filtering by Dimension Attributes
This option lets you filter dimensions by filtered attributes of other dimensions, returning only the filtered values.
In this example, all customers that purchased Product A and Product B will be returned.
Note that you can add as many nested filters as needed.
Updating on Every Change
When this option is on, any changes you make to the dashboard filters are updated immediately, and the dashboard is refreshed to reflect the changes.
If you are working with large or complex data sets that result in longer refresh times, then switch off this option. Make all your changes, and click the Update button when you are ready to update your dashboard.
This option is available for Designers only. Sisense viewers can make changes that will update automatically on very change.
To filter lists or text quickly, you can use wildcards such as ‘_’ or ‘%’, which will be interpreted as literal characters or an empty string.
Sisense supports the following wildcards:
You can enter an underscore ‘_ ‘ as a placeholder for a single unknown character.
You can use a percent % symbol to search for an undefined length of string.
If you are searching for a string with an underscore or percent symbol, add a backslash () in front of the special character. Backslashes are treated as an escape character by Sisense.
For example, to locate results for the string “_te”, use a backslash before the string: