Multiple drop down menus to filter plots/tables

Ed_

Good day all,

I am trying to create a web app in Insights Desktop such that the app has two drop down menus:

1. One for variable of interest 
2. Second for location

As you can see I can select the location column in the 2nd drop down since it's a single column. However, I am unable to select multiple columns (each column representing a different variable, 5 columns/5 variables in my case).

If it it was possible to select multiple columns from a drop down menu, then for example, the user would first select the variable of interest let's say `avm`  that would then show `avm` values for different cities depending on the selection from the 2nd drop down menu. Then if the user selected the variable `flood factor` it would filter location values to `flood factor`.

Is it possible to select multiple columns for a drop down menu in Insights desktop? Such an option will save me from creating separate plots for each variable.

If not can you please have option in the next release?

As such an option will really make the app concise, neat and clean.

Please note that both the drop menus are based on the same dataset.

 

Scott_Aulen

With a big hat tip to @WarrenDavison, here's what I suggest.

Predefined filters are designed to filter values within a column (i.e., variable) and not the variable itself.  To accomplish this we'll need to reshape the data (in this case wide to tall) so that these variables become string values within the the dataset.

I've taken the following dataset which has 4 variables and transformed from wide to tall.

This allows me to create two Predefined filters:

1. Variable filter (Population, MedianHomeValue, Employees, MedianAge)

2. State filter

This is a fairly simple example but hopefully it illustrates the concept.

@Ed_ will this work for what you're trying to do? 

 

Scott