Creating Dependent Filters

Applicable to Sisense on Linux and Microsoft Windows

Dependent Filters combine multiple dashboard filters into a hierarchy of filters where each filter shows only the options relevant to its parent filters. When you filter the parent filter, fewer options will be available in the child filter.

For a short video on dependent filters, see below.

Example Use Case

The following example shows how using a dependent filter helps you easily narrow down the information in a dashboard.

This example describes an online travel agency with 250,000 hotels in its database. An agent wants to find a specific hotel, but does not remember its name. To narrow down the results, the agent can define a dependent filter. This dependent filter is comprised of four sub-dependent filters defined with the following hierarchy:

Note: By default, filters are not dependent. Dependent Filters can be defined only from selection type filters.

To define a Dependent Filter:

  1. The top level (most inclusive) filter of the Dependent Filter must first be defined in the usual manner (see Creating Dashboard Filters). This newly added filter then appears on the dashboard.
  2. On the parent filter, click + or click and then click Add a dependent filter.
  3. Define the child filter in the usual manner (see Creating Dashboard Filters). The number of available options for selection in the child filter is narrowed down because of the selections in the parent filter. The child filter appears on the dashboard with a down arrow indicating the parent filter and its dependent filter below.

  4. Repeat this step for each new child filter to create as many sub-levels of Dependent Filters as you need.