This section explains how to create a dashboard filter, using the different filtering options.

In this section you will learn how to:

Creating a Dashboard Filter

To create a dashboard filter:

  1. 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.
    filterDetails
  2. (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.
  3. Select the field by which to filter.
  4. Select the type of filter from the pane on the left, such as List, Criteria, Calendar or RankingThe options provided in this window may vary according to the selected field type (Date, Numeric or Descriptive).
  5. 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 Favoritestar  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.

Note: Your favorite filters are visible to shared users.

  1. Click OK to filter the data in the Dashboard and add this filter to the FILTER panel on the right of the Dashboard.

After a filter has been added to the Dashboard, it stays displayed on the Dashboard’s FILTER panel. Any changes that you make to the filter are immediately reflected in the Dashboard.

Tip: You can rearrange the filters in the Filters panel by dragging a filter above or below another filter.

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:

  1. Follow steps 1 – 3 of Creating Dashboard Filters.
  2. Select the List option in the left panel.filterList
  3. Select/clear the field values to be included/excluded in the Dashboard.
  4. 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:

filterMulti

Single Selection:

filterSingle

Creating a Text Filter

This type of filter enables you to filter according to text matching.

To define a Text filter:

  1. Select the Text tab.
  2. Follow steps 1 – 3 of Creating Dashboard Filters. Select a Textual field.
  3. Select the operator, for example Starts with or Containing.
  4. Type in the value by which to filter.
  5. If you require additional conditions, click + Add condition. Select AND or OR to define how filter operators are combined.

filter text

Creating a Numeric Value Filter

This type of filter enables you to limit your dashboards to specific value ranges. For example:

  • Keep only sales above 100$.
  • Keep only product IDs between 1000020 and 1000030.

To define a Numeric filter:

  1. Select the Values tab.
  2. Follow steps 1 – 3 of Creating Dashboard Filters.
  3. Select the operator, for example Equals or Greater than.
  4. Type in the value by which to filter.
  5. If you require additional conditions, click + Add condition. Select AND or OR to define how filter operators are combined.

filter value

Creating a Top/Bottom Ranking Filter

This type of filter enables you to select whether to include only the top/bottom ranking fields.

To define a Ranking filter:

  1. Follow steps 1 – 3 of Defining Dashboards Filters
  2. Select the Ranking filter tab. filterRank
  3. Select Top or Bottom and the number of items to include.
  4. In the By field, select a field by which to rank the fields. A list of the fields that match these definitions is displayed so that you can verify that the results are as you expect.
  5. Click OK to filter the data in the Dashboard and add a Ranking filter to the FILTER panel of the Dashboard.

Creating a Time Filter

There are two types of time filtering options:

Calendar Filter

This filter enables you to select custom date ranges from a calendar.

To define a Calendar filter:

  1. Follow steps 1 – 3 of Creating Dashboard Filters. (Select a date field).
  2. Select the Calendar filter tab.
  3. Use the quick navigation menu to jump to a point in time.
  4. Select a date range using any of the following methods:
    • Click on a start and end date.
    • Type in the dates, or use a shortcut such as Earliest Date or Today.
      Note: Earliest Date and Latest Date refer to the earliest and latest dates with data.

new cal

Note: Unlike other filters that you define, viewers will be able to change the type of date filter, providing more flexibility for viewing date ranges. For example, from Time Frame to Calendar, etc.

Creating a Dynamic Time Filter

This filter enables you filter dashboards to preset dynamic time frames, such as ‘Last Year’, ‘Last 2 Years’, ‘2 Year ago’, etc.

To define a dynamic time filter:

  1. Follow steps 1 – 3 of Creating Dashboard Filters. (Select a date field)
  2. Select the Time filter tab.
  3. Use the calendar to select a date range to filter by. Use the left calendar to select the starting date of the range, and the right calendar to select the end date.
  4. 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:

  1. Click Advanced in the left panel.
  2. Add or edit filtering criteria. Click Test to see the results of your new/edited filter.
  3. 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.

advanced filter

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.

The query:

eg1

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.

eg2

Note that you can add as many nested filters as needed.

Using Update 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.

update

Note: This option is available for designers only. Sisense viewers can make changes that will update automatically on very change.