Better handling of missing data when creating combo-box filters
A
Adam Gross
This feature request would be to allow users to omit the "Missing Data" category from being a selectable option in a combo-box control, but still allow the "(All)" selection to mean "all respondents."
Users will often create a combo-box filter that uses a variable that has missing data.
However, it might be undesirable to include "Missing Data" as an item in the combo-box or list box. (See the screenshot attached, for example).
In these cases, the user wishes to remove the "Missing Data" option from the combo-box, but this changes the mechanics of the combo-box filter.
Now, when "(All)" is selected in the combo-box, this does not represent ALL respondents; rather, it represents all the matches with the list of text that is in the combo-box.
The workaround for users is to program an "if statement" in the R Code of the combo-box filer.
For example, in the screenshot below, if a user wants to omit "Missing Data," from the list of options in the combo-box, doing so will cause "Missing data" to be filtered out of the combo-box filter.
Instead, what they can do is modify the code of the Combo-Box filter to something like:
if (length(combo-box) == 9 {rep(1, length_of_data_set)}
else {
<normal combo-box filter mechanism>
}