Creating dataset filters on a dashboard

Cloudera Data Visualization enables you to add a filter widget to the dashboard based on any field in the dataset.

The following steps demonstrate how to create dataset filters on a dashboard.

Open an existing dashboard in Edit mode.
Go to the Filters tab on the Dashboard Designer side menu bar.
Check that you are using the correct connection for the filter. If not, switch to the desired connection.
Select the dataset for the filter.
Click any field of the dataset to add a widget to the dashboard that filters on this field.
Alternatively, you can also drag the field that you want to use as a filter and drop it into the filter bar on the dashboard.
You can see a new filter widget added and named after the field you have used. You can hover over the widget to access filter actions in the top-right corner.
- Clicking the Move icon moves the filter to the grid area.
- Clicking opens the Settings modal window that allows you to configure the filter.
- Hovering over the Info icon displays the filter's information modal, providing information about the visual and the dataset.
- Clicking the Cross icon removes the filter from the dashboard.
To set basic configuration for the new dashboard filter, click in the top right corner.

The Settings modal window opens on the Values tab, showing the dataset of the filter and several configuration options.
1. If the filter is based on a dataset, you can switch the filter to another dataset and connection by clicking .
2. To preserve the adjusted filter settings for View mode, select the Save selections made in edit mode option. You can use it to save all changes made in Edit mode.
3. You can use the Permit selection of NULL values setting to exclude null values for all filter types.
4. From Base field specifies the filter-controlling field. You can change the base field to another field of the dataset. This option is available only in dataset-based filters.
5. Title shows the name of the filter as it appears in the application at run-time. Keep it short and descriptive providing information on the filter's function.
6. Output Parameter is the parameter sent to the target visual to determine which field to display. In cases of optional or variable parameters, output parameter is used on the shelves of the target visual, such as <<[dim], or <<[agg], or in an expression that contains the variable.
  
  When used in filters that are based on existing fields, the output parameter ensures field name match across datasets. For example, a filter that is based on the state field in the US State Populations Over Time dataset must have the output parameter stname to control visuals in the US County Population dataset.
7. Filter Fields specifies the base fields of another field, based on which options of the current filter can be filtered. You can enter multiple base fields separated by a comma. This option is available only in dataset-based filters.
Click APPLY to save the configuration settings.

For more information on further configuration options, see the following documentation.