In Cloudera Data Visualization, application controls can use custom output
parameters. You can use custom output parameters for application controls. This allows you to
apply a filter from one dataset to control the visual presentation of another
dataset.
Often, the field names between the source (driver) and target datasets do not match. You
can resolve this by mapping the filter’s value to the correct field in the target
dataset.
The following steps show you how to configure a filter based on the US State Populations
Over Time dataset to control a visual based on the US County Population
dataset.
Open an existing dashboard in Edit mode or create a new one.
Ensure that includes visuals from both datasets. If not, click the
Visuals tab on the left navigation and add the required
visuals.
Click the Filters tab and select the US State Populations
Over Time dataset.
Under Dimensions, click the state field to add
it as a filter.
Hover over the added filter until controls appear in the top right corner, then click
.
The Settings modal window opens on the
Values tab.
Configure the following values:
Title: Set to States.
Output Parameter: Set to stname.
Click APPLY.
In the state filter, click Select and
chose the following:
AK
AL
AR
In the top right corner of the application, hover over to
review the current filter parameters.
This reports the current filtering parameters. The output parameter is correctly named
stname, and the filtering conditions applied earlier are displayed.
If the Emit distinct parameters for each item selected option is
selected on the Display Settings tab, the filter reports each
selection as distinct key/value pairs. By default, the label for each key is derived
from its value. However, if labels are specified (for example, when using optional
parameters), they will be displayed instead.