topic Re: Show null values in a number selector (operations dashboard) in ArcGIS Dashboards Questions

Show null values in a number selector (operations dashboard)

LukeSussex2 — Wed, 31 Jan 2018 02:22:29 GMT

In operations dashboard, I have a field with number values some of which are null. I would like to view the info using the number selector, displayed as a slider, but none of the null values show up e.g. the slider shows results from 0 to 200,000. How do I add an option to select the null values?

Re: Show null values in a number selector (operations dashboard)

DavidNyenhuis1 — Wed, 07 Feb 2018 23:11:36 GMT

Hi Luke Sussex‌,

Thanks for the question and details about your use case. Unfortunately, at this time there is not a way to include null values from a number selector (when applying a filter action to another element). This is a good enhancement idea, however. I will bring it to the team for consideration.

Dave

Re: Show null values in a number selector (operations dashboard)

JoeBryant1 — Thu, 18 Apr 2019 15:48:05 GMT

What's the status of this? I am finding that adding null string values to Category Selectors using the "+ Override" button is also not possible in Operations Dashboard.

Re: Show null values in a number selector (operations dashboard)

Anonymous User — Tue, 31 Dec 2019 14:55:14 GMT

I logged in to ask about this. I have null values in one field and I want the user to be able to select that, because it is meaningful.

I am going to recalculate "NULL" to "No Data" (text) and that should do it but the data is updated regularly, so I will have to recalculate whenever the data is updated. Also, I have large datasets and the calculation is taking a very long time.

Re: Show null values in a number selector (operations dashboard)

JoeBryant1 — Tue, 31 Dec 2019 16:19:58 GMT

Recalculating <Null> to 'No Data' sounds like a good work around, Randy. I will try that in the future.

After calculating your current data, I would change the field to not allow <Null> values and set a default value of 'No Data'. That way all new data that comes in will have this field populated and usable. Just remind your editors to update this field from 'No Data' to whatever is appropriate when needed.

Re: Show null values in a number selector (operations dashboard)

Anonymous User — Tue, 31 Dec 2019 16:38:03 GMT

Thanks for the suggestion about updating the field that I don't want Null values in. I didn't realize you could set a default value when you prohibit Null values. I'll try that.

Re: Show null values in a number selector (operations dashboard)

JoeBryant1 — Mon, 21 Dec 2020 18:11:14 GMT

Update: I've created an enhancement idea for selecting Null values:

Add Null Override Category to Dashboard Selector

Re: Show null values in a number selector (operations dashboard)

PaulodeCastroVilli — Wed, 28 Jun 2023 19:22:40 GMT

The simple workaround I found is using Arcade to replace Null with another value in an Arcade data source based on your current data source:

Documentation: https://developers.arcgis.com/arcade/profiles/dashboard-data/
Arcade Data Source Examples: https://github.com/Esri/arcade-expressions/tree/master/dashboard_data

BUT!!!

This works fine for domain attributes and strings... it does not work so well for numeric fields where there isn't a restricted valid numeric range

eg: you can't replace NULL with 0 if there are actual cases where 0 is a valid attribute value

an arbitrarily large, small or negative number might also mess things up horribly (eg: scale) without really ensuring you can differentiate it from valid numbers...

...and by then you realize NULL itself is the only safe out-of-range option... so it should be optionally possible to reach records with NULL value in all filters