Configuring data options for a dashboard filter

Cloudera Data Visualization allows you to configure data options of a newly created field-based or custom filter in a dashboard.

  1. Click on the filter widget.

    The Settings modal window opens on the Values tab.

  2. Click the Data tab.
  3. Configure the following settings.

Changing number of initial options in dashboard filters

In a dashboard filter, you can control the number of initial options that appear in the dashboard filter at loading time. This limits the display of options for datasets with a very large variability.

  1. Enter a value in the Maximum default number of values displayed.
    The default is 1000.
  2. Click APPLY.

Changing number of options in search output of dashboard filters

In a dashboard filter, you can change the maximum number of options that appear during search. This limits the display of options for datasets with a very large variability.

  1. Enter a value in the Maximum number of search results displayed.
    The default is 1000.
  2. Click APPLY.

Disabling incremental queries in filters

Cloudera Data Visualization allows you to disable incremental queries at the level of the dashboard filter. Incremental queries return preliminary results quicker and paints the visuals on the dashboard, and then adjusts the level of detail as more results are incorporated into the calculations. Disabling this feature delays the painting of the visuals until all results are in.

  1. Select the Disable incremental queries, overriding field-based-level setting option.
  2. Click APPLY.

Configuring sort order in filter values

Cloudera Data Visualization allows you to select the sort order of filter values. There are different sort order options available on field-based filters and custom filters.

  1. Select the Filter Options Sort Order option.

    Sort Order of Filter Widget Values on Field-based Filters

    For a field-based filter, there are two sort options available under the Filter Options Sort Order setting:

    • Ascending
    • Descending

    By default, filter widget values are displayed in ascending order (image on the left). In this example, to see the most recent population of Australia first, select the Descending option (image on the right).

    By default, filter widget values are displayed in ascending order. In our example, to see the most recent population of Australia first, select the Descending option.

    Sort Order of Filter Widget Values on Custom Filters

    For a custom filter, there are three sort options available under the Filter Options Sort Order setting:

    • Ascending
    • Descending
    • Default

    The default setting of the sort order in a custom filter is Default. In the following image, notice that the default sort order in the filter widget is the same as the lables of the custom filter added in the Values tab: Country, Year, Region, and GDP.

    You can select the Ascending option to change the sort order to country, GDP, Region, and Year, or select the Descending option to change the sort order to Year, Region, GDP, and Country.

  2. Click APPLY.