UPCOMING WEBINAR: From Thousands of Tables To One Clear Story: using AI in survey analysis This article describes how to combine the code within two or more R filter variables that are connected to control boxes into a single filter variable.
Requirements
- Two or more control box filters set up from an R-based method in How to Create a Combo Box Filter. This includes:
- Two or more control boxes (created via Control
).
- Two or more R filter variables that reference these control boxes.
- Two or more control boxes (created via Control
Method
In short, this is as easy as copying the original code from both variables and combining them with the & (AND) symbol.
- In the Data Sources tree, hover over a variable and click Plus (+) > Custom Code > R > Numeric.
- Give it a Label such as Combined Filter in Properties
> General > General.
- Check the Usable as Filter checkbox in Properties
- In the Data Sources tree, select the first filter that you want to combine and copy the code from Properties
panel of your new Combined Filter.
- In the Data Sources tree, select the second filter that you want to combine and copy the code under Data > R Code - Data > Edit Code in Properties
- In the Code
&(for AND) and then paste in the filtering code from the second filter variable.
Example #1: Below are two R code snippets for an Age filter and Gender filter, respectively:
Age %in% combo.box.age Gender %in% combo.box.genderThe R Code for the Combined Filter is:
Age %in% combo.box.age & Gender %in% combo.box.genderHere, the logic is looking at whether the selection in combo.box.age matches the category in the Age variable AND the selection in combo.box.gender matches the category in the Gender variable.
Example #2: This process will work on any type of filter, using both a multiple and single-response filter - such as Brand Awareness and Income is below:
rowSums(`Brand Awareness`[, combo.box.brand, drop = FALSE]) > 0 & Income %in% combo.box.incomeHere, the logic is looking at whether the selection in combo.box.brand has been selected in the Brand Awareness variable set AND the selection in combo.box.income matches the category in the Income variable.
Notes
Keep in mind, the final result of any combined filter must be a TRUE/FALSE or 1/0. By using the & operator, the result will only return TRUE if both conditions are TRUE. If you'd like to add in an OR condition, you can use the | symbol.
See Also
How to Work with R in Displayr
How to Connect Filters to Controls using R Code
How to Create a Combo Box Filter