topic Re: "Select all" from Dropdown Predefined filter? in ArcGIS Insights Questions

"Select all" from Dropdown Predefined filter?

chelynnes — Tue, 30 Nov 2021 16:00:54 GMT

Hey, we're looking to use dropdown predefined filters to create a Select all option, to go along with the individual values.

We were using "group" to do this, but it's not allowing us to integrate items without values into this group.
Also, on certain filters, it isn't even allowing us to select all the values to create this group!

Help?

**We do not want to use multi-select for space reasons on the dashboard.

Thanks!

Re: "Select all" from Dropdown Predefined filter?

LauraBecht — Tue, 30 Nov 2021 16:11:10 GMT

Hello,

When i am using a drop down filter and need to do the select all option, i use the advanced filter and say something like [group] <> '' or whatever statement selects all values for what you are filtering.

Hope this helps!!

Laura Becht

Re: "Select all" from Dropdown Predefined filter?

chelynnes — Tue, 30 Nov 2021 16:38:38 GMT

Hmm, this doesn't seem to be working for me at all.

So you're selecting whichever column the data is coming from in the bottom right, then the '<>'?

So....: Country <> for example ?

Re: "Select all" from Dropdown Predefined filter?

chelynnes — Tue, 30 Nov 2021 16:41:17 GMT

I have had success in the advanced filter by saying 'Country = Country' as a select all, but this does not work if there's blank fields.

If there's blank fields, even when it's set to this option as a select all country, it's affecting the number on entries that my dashboard is reading. It's automatically filtering out all the entries that didn't have a country input off the entire dashboard, which is a major issue.

Re: "Select all" from Dropdown Predefined filter?

LindaBeale — Tue, 30 Nov 2021 17:05:41 GMT

Hi @chelynnes

Just as @LauraBecht suggests, the way to do it is to create an advanced filter and select anything that is not null (e.g. Country <> ''). There is now that option using ISNOTNULL just to make it a little easier.

Re: "Select all" from Dropdown Predefined filter?

LauraBecht — Tue, 30 Nov 2021 16:56:03 GMT

For example, if i am filtering for country like your example, i would say "Country <> 'm'". Which would include blank values if they exist. if you want to exclude all blank/null values add "OR Country <> '' OR Country IS NOT NULL" I believe a dev told me you can use the null check. Please correct if i am wrong.