topic Multiple drop down menus to filter plots/tables in ArcGIS Insights Questions

Multiple drop down menus to filter plots/tables

Ed_ — Tue, 19 Apr 2022 15:02:40 GMT

Good day all,

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

One for variable of interest
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.

Re: Multiple drop down menus to filter plots/tables

LauraBecht — Tue, 19 Apr 2022 15:04:15 GMT

Hi Saadullah,

There is a way to filter using multiple columns, you would use the advanced filter option in the predefined filter. You can select non null values for each column as a separate option in the filter, then go from there.

Regards,

Laura

Re: Multiple drop down menus to filter plots/tables

Ed_ — Tue, 19 Apr 2022 15:32:31 GMT

@LauraBecht ,

Thank you for the quick response, so what function should I use in the query?

My columns of interest for the 1st drop down menu are:

Flood Factor
avm
adapt_type
adapt_name
adapt_rp

Re: Multiple drop down menus to filter plots/tables

LauraBecht — Tue, 19 Apr 2022 15:12:42 GMT

I don't think i completely understand your goal. You want to select a given city, then you want to select for combinations of these variables? At one time dynamically?

Re: Multiple drop down menus to filter plots/tables

Ed_ — Tue, 19 Apr 2022 15:24:33 GMT

So I want the user to be able to select a variable of interest out of the 5 total variables (5 columns). let's say the user selects `avm` out of the 5 available options from the 1st drop down menu.
Then the user will select the city (`cities` column) from the 2nd drop down menu. Let's say the user selects Coconut Creek.
The app will then filter the map and table to show `avm` values for Coconut Creek.

Re: Multiple drop down menus to filter plots/tables

Ed_ — Tue, 19 Apr 2022 15:33:45 GMT

@Scott_Aulen when you have the time, can you please also look into this?

Thank you,

Re: Multiple drop down menus to filter plots/tables

Scott_Aulen — Tue, 19 Apr 2022 15:56:41 GMT

I've looked at this a bit but haven't been able to fully explore. Hoping to find some time this afternoon.

Re: Multiple drop down menus to filter plots/tables

Ed_ — Tue, 19 Apr 2022 15:59:36 GMT

Cheers mate

Re: Multiple drop down menus to filter plots/tables

Ed_ — Wed, 20 Apr 2022 16:12:19 GMT

Good day @Scott_Aulen,

If the intended purpose in the post is not currently possible in Insights, should I post in Insights Ideas too?

Thank you,

Re: Multiple drop down menus to filter plots/tables

Scott_Aulen — Wed, 20 Apr 2022 17:45:03 GMT

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

Re: Multiple drop down menus to filter plots/tables

Ed_ — Wed, 20 Apr 2022 19:09:44 GMT

@Scott_Aulen, thank you for the detailed response. So, I need to transform the dataframe to either of the following two right, so which one of these would be the right approach 1or 2?

Cheers,

Re: Multiple drop down menus to filter plots/tables

Scott_Aulen — Wed, 20 Apr 2022 19:15:57 GMT

That's correct, you'd want Option 2. You want to move all three variables (FF, AL-2021, AL-2051) to one column (which you have labeled variable).

Re: Multiple drop down menus to filter plots/tables

Ed_ — Wed, 20 Apr 2022 21:33:39 GMT

@Scott_Aulen worked like a charm, I had to slightly modify the data as suggested in R. For that I had to use the `pivot_longer` function via `dplyr`. Thanks again.

Relevant code in R:

library(tidyverse) df = df %>% select(long, lat, FF, AL_2021, AL_2051, District, City, Zipcode) %>% pivot_longer(c(FF, AL_2021, AL_2051), names_to = "Variable", values_to = "Value")