Use Dependent Filters to combine multiple dashboard filters into a hierarchy of dependent filters that affect each other from parent, to child, to grandchild and so on. When a user filters the parent filter, fewer options will be available in the child filter.

Example Use Case

The following example shows how using a Dependent Filter helps a user easily focus 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 the results, the agent can define a Dependent Filter. This Dependent Filter is comprised of four sub-dependent filters defined with the following hierarchy:

funnel

  • Destination: Displays a list of States and Countries. In this example, the agent will select the Destination Florida.
  • City: Because Florida was selected, only Destinations in Florida are displayed in the child filter, such as: Miami, Orlando and Tampa. In this example, the agent will select the City Orlando.
  • Resort: Because Orlando was selected, only resorts in Orlando are displayed in the grandchild filter, such as Floridays, Buena Vista, Walt Disney World. In this example, the agent will select the Walt Disney World resort.
  • Hotel: Because Walt Disney World was selected, only the Hotels in Walt Disney World are displayed in the great-grandchild filter.

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

To define a Dashboard 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.

depfil

  1. On the parent filter, click the Cascading Filters - 4 or click  Cascading Filters - 5 →  Add a dependent filter.
  2. Define the child filter in the usual manner (see Creating Dashboard Filters). The number of available options for selection in the child filter are less because of the selections in the parent filter. The child filter appears on the dashboard with a down arrow indicating the dependent filter and its parent above.

 depfil2

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