Filter All Data Discovery

The Filter All data discovery mode lets you to define a visual in the dashboard as a 'source', so clicking on a specific element of the source controls the appearance of other visuals in the same dashboard. The source sends filter parameters to the target visuals, which they use to define the output. Keep in mind that any visual can be both a source and a target when passing filter parameters.

The following conditions apply to Filter All functionality:

The following sections demonstrate how to set up a dashboard with Filter All data discovery options, using dataset scope.

Note that a visual may be both a target, and a source.

Preparing Target Visuals

Here, we are using the following two visuals:

A line visual Life Expectancy that has the following settings:

  • X Axis shelf: year, sorted in chronological order
  • Y Axis shelf: life_expectancy, as avg(life_expectancy)
  • Colors shelf: country
  • Under Settings, select the Parameters menu, and make sure that the, Receive parameters with explicit scope option is not enabled.

Another line visual Life Expectancy and GDP that has the following settings:

  • X Axis shelf: year, sorted in chronological order
  • Y Axis shelf: life_expectancy, as avg(life_expectancy)
  • Colors shelf: gdp_per_capita, as avg(gdp_per_capita); select the field on the shelf to view the Field Properties menu, expand Axis, and select Secondary Axis.
  • Under Settings, select the Parameters menu, and make sure that the, Receive parameters with explicit scope option is not enabled.

Preparing the Source Visual

For the source (controlling) visual, we are using a bar visual World Population, with the following configuration:

  • X Axis shelf: un_region. You can also choose to use a dimensional hierarchy that represents the [un_region | un_subregion | country] tuple.
  • YAxis shelf: population, as sum(population); alias it as Population.
  • Filters shelf: year, set to 2010
  • Under Settings, select the Parameters menu, and enable the Send parameters with dataset scope option. Do not select other options in this menu.

.

Preparing and Using the Dashboard

  1. Create a new dashboard, and add the three visuals to it. We re-sized the source visual so it occupies the left side of the dashboard, while the target visuals share the right side of the dashboard.

    Dashboard for Filter All
  2. Switch to View mode.
  3. Click on one of the bars of the source visual (we used Oceania), and select the Filter All option.

    Filter All dashboard, filtering on un_region = Oceania
  4. Arcadia Enterprise refreshes the dashboard to show the target visuals that contain information about the selected un_region only. You can see the value of the filters on each visual when you hover the pointer over them, or the value of the dashboard parameters when you hover over the (filter) icon.

    Filter All dashboard with parameter un_region = Oceania
  5. Note that any visual can be both a source and a target when passing filter parameters.

    To examine data outliers in one of the 'target' visuals, click on that element. In this example, we can check for more details in the Life Expectancy visual by investigating the drop reported for Turkey in 1915.

    Click on that part of the line chart, and select Filter All.

    Filter All dashboard, filtering on un_region = Oceania
  6. Arcadia Enterprise refreshes the dashboard to show the effect on the other visuals. For example, the Life Expectancy and GDP shows that the GDP per Capita in Turkey for 1915 was 1.52k.

    Filter All dashboard with parameter un_region = Oceania