idea More query operators for the Category Selector in ArcGIS Online Operations Dashboard in ArcGIS Dashboards Ideas

More query operators for the Category Selector in ArcGIS Online Operations Dashboard

Zach_Robinson — Thu, 27 Dec 2018 23:17:08 GMT

The Category Selector in Operations Dashboard currently allows Single choice selections and Multiple choice selections. The query operators for Multiple choice selections are "include" or "does not include." These operators do not offer the same functionality as the operators "contains" or "does not contain." ESRI Customer Support explained this to me in an email:

I've done some digging into this issue and I think I've pinpointed the confusion.The 'include' operator works as an 'equals' operator when only one value is selected, works as an 'IN' operator when multiple values are selected, but never works as a 'contains' operator. This means that the query is looking for fields that exactly match the string you've configured as the query value. The result of this is that when you select multiple values, for example [category1] AND [category2], the category selector will filter to show only features that have [category1] OR [category2] as the value for the selected field. However, a feature that has the value of [category1,category2] would not be shown because the value is not an exact match despite containing both search terms.

My idea is to add two additional operators to the Category Selector in Operations Dashboard: "contains" and "does not contain." These operators will allow querying categories that are comma-separated in a single field. (This comma-separated format is standard for Multiple Choice data from Survey123.)

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

Katie_Clark — Wed, 03 Apr 2019 17:58:49 GMT

Absolutely! It would be great if the category selectors functioned the same way as a typical filter, which would allow for 'contains' and 'does not 'contain'. The way it is now is a huge setback for Operations Dashboard.

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

DarrylKlassen1 — Mon, 08 Apr 2019 18:02:20 GMT

I would also really find this useful. This is roadblock in my workflow if I want to use operations dashboard. Please add this enhancement ESRI.

Thanks

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

BrianMcElroy — Wed, 03 Jul 2019 16:39:18 GMT

This would be a very useful addition. Piggybacking off this to also suggest adding a "Null" or "Is Blank" option.

I've seen something similar mentioned here, but there hasn't been much follow-up.

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

BrantCarman — Wed, 17 Jul 2019 19:39:32 GMT

Yes, the operator options for the selector tool in Operations Dashboard seems to have been overlooked at ESRI. Most other filter/query tools within ArcGIS Online seem to have a lot more options for building some very useful queries.

Would love to see some input and movement on this from the Operations Dashboard team, as the lack of operators is really limiting.

Thanks!

Operations Dashboard for ArcGIS

filter using operations dashboard

operations dashboard for argis‌

Derek Law‌

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

TanGnar — Mon, 06 Apr 2020 12:11:05 GMT

Agree this would be very useful. For example, I have a field with a list of counties (Abbeville, Anderson, Bamberg…) impacted by weather events. There is no easy way (that I can tell) of using the selector to get all of the storms that impact X county. Another field has list of weather impacts (Heavy Snow, Ice Storm, Wind Chill), which presents the same problem. I can’t easily find all Ice Storm events with a selector.

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

MTaft-Ferguson — Tue, 28 Jul 2020 12:29:13 GMT

Operations Dashboard and Experience both! We have use cases very similar to Tanner's list of counties/impacts above and it's a real shame we can't use Ops Dash for these.

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

CRose — Thu, 17 Sep 2020 18:05:46 GMT

I would also really appreciate this functionality; I have a field 'Researchers' that is a list of names, separated by semicolons. I want to provide a drop-down menu of the individual names, and have it filter to all points where that name appears in the list of researchers.

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

HolgerWöhrle — Fri, 02 Oct 2020 06:34:06 GMT

Just yesterday I needed this query operator for a dashboard but couldn't find it. So vote up for this great idea!

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

NeilWebber — Thu, 19 Nov 2020 11:52:42 GMT

This idea gets a big upvote from me. Given that Survey123 collects multi-select answers as comma separated lists, and that dashboards are a great way to review and analyse survey results, the lack of a way to use a grouped values Category Selector to effectively query and filter on such a list via a "CONTAINS" statement seems like a big omission.

And given that so many other widgets in the AGOL ecosystem allow these types of queries, could this not be a relatively quick win to implement?

It'd be great to hear thoughts from someone at ESRI on this idea.

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard - Status changed to: Under Consideration

patrickb — Tue, 08 Dec 2020 21:41:53 GMT

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

JoeBryant1 — Mon, 21 Dec 2020 18:15:17 GMT

I also created an idea for adding a Null Category Selector for string fields here:

Add Null Override Category to Dashboard Selector

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

Amanda__Huber — Wed, 10 Feb 2021 15:24:07 GMT

"Add two additional operators to the Category Selector in Operations Dashboard: "contains" and "does not contain.

To contribute our voice to this, our organization is desperately looking for this solution as well. We have multiple dashboards that need this functionality for end users and we have no solution for this.

@DerekLaw , could you please provide us with an update for when or if this functionality will become available?

Thanks a million!

Amanda

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

DerekLaw — Fri, 12 Feb 2021 19:37:01 GMT

Hi @Amanda__Huber ,

Regarding your specific inquiry,

"Add two additional operators to the Category Selector in Operations Dashboard: "contains" and "does not contain.

This is not on the short term Dev roadmap, but is still being considered by the Dev team. Right now, they are focused on getting ArcGIS Dashboards Beta to a final, official release. They're also working on improving the UX for viewing dashboards on mobile devices.

Hope this helps,

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

WilliamRockwell1 — Wed, 08 Sep 2021 11:56:07 GMT

Odd that I can do number and date filters in a dashboard, but not text?

Why no text selector?

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

Amanda__Huber — Wed, 08 Sep 2021 13:44:06 GMT

@DerekLaw Thanks so much for the update back in February. Just thought I'd see if there was any plan to implement this functionality?

We're currently using the S123 data tab filters as the workaround, but we would love to leverage dashboards instead!

Thank you, and hope you're doing well!

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

DerekLaw — Tue, 14 Sep 2021 02:58:29 GMT

Hi @WilliamRockwell1,

> Odd that I can do number and date filters in a dashboard, but not text? ... Why no text selector?

Why can't you use a Category Selector to emulate this functionality?

Hi @Amanda__Huber,

> Just thought I'd see if there was any plan to implement this functionality?

Sorry, I don't have any update to share. As I said previously, it is being considered, but is not currently a priority.

Hope this helps,

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

WilliamRockwell1 — Tue, 14 Sep 2021 13:08:52 GMT

@DerekLawI have thousands of possible text to choose from, the category selector is not really capable of doing this. (that I'm aware of)

For example, if I have an location field, and I want to be able to filter all the records that have "Main Street" or "1st Ave" and thousands of other options, there's no way I can do this. I could use a category selector of features and get each individual location (not what I want) or defined values (also not what I want) and group values for every street isn't feasible. And that's even before you run into the maximum category issue.

Oddly you can accomplish this in an Experience, but it lacks the easy-to-use nature of a dashboard. I was just hoping the functionality can be added to the dashboard since you can do it in an Experience.

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

DerekLaw — Tue, 14 Sep 2021 14:35:45 GMT

Hi @WilliamRockwell1,

Thanks for the additional info and context on your use case. I suggest that you create a new, separate enhancement request on ArcGIS Dashboards ideas for this, so others can vote for it.

Hope this helps,

Re: More query operators for the Category Selector in ArcGIS Online Operations Dashboard

MikeLachance1 — Fri, 11 Mar 2022 16:13:28 GMT

I am also interested in this functionality. I have a multi-select field in my survey and I would like to create a category selector that can filter for individual values in that field. Currently the includes operator will not pick up the selected staff name if another staff name appears in the field value separated with a comma. It feels like labelling this as 'includes' is a bit misleading based on the functionality it offers.