topic Re: ArcGIS Dashboard Number selector automatically filtering records in dashboard as some features have no value in ArcGIS Dashboards Questions

ArcGIS Dashboard Number selector automatically filtering records in dashboard as some features have no value

LJackson29 — Wed, 20 Mar 2024 15:25:05 GMT

Hello -

I am using ArcGIS Online Dashboards, and am trying to create a number selector so users can select a range of projects based upon an integer field (rank score 1-500). Not all projects have have a rank, as a result all projects that do not have a rank are automatically being filtered out of the whole dashboard which we do not want. Is there a way to turn off the number selector by default (similar to Experience Builder) or have it ignore the null values?

Thanks,

Leila

Re: ArcGIS Dashboard Number selector automatically filtering records in dashboard as some features have no value

jcarlson — Wed, 20 Mar 2024 20:24:16 GMT

Number selectors always operate in a way that ignores nulls. You could get around this with a Grouped Values selector looking at the same field. This might result in gaps in the numeric range for values not present in the data, and also means you can't use a nice "slider" selector, but it would preserve nulls in the data.

Re: ArcGIS Dashboard Number selector automatically filtering records in dashboard as some features have no value

LJackson29 — Mon, 25 Mar 2024 16:33:40 GMT

Hi Josh -

@jcarlson Thanks for the idea, but each record has a unique value so I can't really group them using the grouped values. I am trying to figure out how to write an arcade data expression that will group the values (1-50, 51-100...) and then use the grouped values, but am having problems with my code - I keep getting an error "Cannot access value using a key of this type" and not sure what that means.

Re: ArcGIS Dashboard Number selector automatically filtering records in dashboard as some features have no value

jcarlson — Mon, 25 Mar 2024 17:39:07 GMT

A data expression could do it, but to actually filter the rest of your dashboard, it would need to hang onto the objectid. Could get tricky, though doable.

Where would you want null values to show up? What about just filling nulls with something else, like -1 or 501?

Re: ArcGIS Dashboard Number selector automatically filtering records in dashboard as some features have no value

LJackson29 — Wed, 05 Jun 2024 14:06:09 GMT

@jcarlson Just discovered that if you select the spinner option vs. the slider option, there is an option for "Allow None" that resolves this issue. I like the slider better as it is more compact and easier to use, but the spinner will work. Thanks for your help.