How to Create a Combo Box Filter

Introduction

This article describes how to create a Combo Box control and use it as a filter. The article contains the steps to take you from a Page containing a grid of bars chart....

...to a Page containing a Combo Box that can be used to filter the chart.

Requirements

A Displayr document containing a data set.
A Displayr data object to filter (e.g., table, chart, visualization, etc.).
A single-response variable to use as a filter (automatic method only).
A Nominal or Binary-Multi variable to use as a filter (manual method only).

Method - automatic

Select the output(s) you wish to filter with the Combo Box.
Go to the Anything menu and select Filtering > Combo Box (Drop-Down) Filters on an Output.
Select the single-response variable(s) you wish to use as a filter.
Select Yes to allow the user to select more than one category in the Combo Box control, or select No to allow the user to select one category only.

A Combo Box control will appear on the Page. Displayr will create a new Combo Box Filter variable linked to the Combo Box selection. Displayr will also automatically apply the filter variable to all the outputs selected in Step 1.

Method - manual

Step 1: Create a Combo Box control:

In the Data Sets tree select the single-response or Binary-Multi variables you wish to use as a filter.
Create a table by drag and dropping the variable from the Data Sets tree onto the Page.
Go to the Anything menu and select Page Design > Control > Combo Box (Drop-down).
Select the Combo Box control, and go to the object inspector > Control > Item list > remove the default text.
In the Items from the dropdown menu select the table created in step 2 (e.g., Age).
In the Selection mode dropdown menu select Multiple selection to allow the user to select more than one category in the Combo Box, or select Single selection to allow the user to select one category only.
OPTIONAL: to change the text appearing in the Combo Box, input the desired text into Placeholder (e.g., Select the age categories to filter).

Step 2: Create the filter and link it to the Combo Box control:

Go to the Anything menu and select Data > Variables > New > Custom Code > R - Numeric.
Set the filter Label (e.g., Age filter).
Paste in one of the following code snippets in R CODE based on the structure of your filter variables.
- Using a Nominal variable to filter: Where Age refers to the name of the variable you wish to use to filter, and Combo.box refers to the label of the Combo Box control.
```
Age %in% Combo.box
```
- Using a Binary-Multi variable set for a multiple-response question: Where Awareness is the variable set used to filter, and Combo.box refers to the label of the Combo Box control. The combo box list items should correspond exactly with the labels of the variables inside the variable set.
```
rowSums(Awareness[, Combo.box, drop = FALSE]) > 0
```

Step 3: Apply the filter to desired outputs:

Select the item that you wish to filter
Go to object Inspector > Inputs > FILTERS & WEIGHT > Filter(s), and choose the filter.

You can also combine multiple combo boxes into the same filter (step 2), please see How to Combine Multiple R Filter Control Variables into a Single Variable.

Articles in this section

Introduction

Requirements

Method - automatic

Method - manual

Step 2: Create the filter and link it to the Combo Box control:

Step 3: Apply the filter to desired outputs:

See Also

Comments

Articles in this section

Introduction

Requirements

Method - automatic

Method - manual

Step 2: Create the filter and link it to the Combo Box control:

Step 3: Apply the filter to desired outputs:

See Also

Related articles