topic Re: Only display not null attribute values in list? in ArcGIS Dashboards Questions

Only display not null attribute values in list?

JasonCyphers — Sun, 22 Nov 2020 12:45:32 GMT

Is there a way to only display attribute values that are 'not null' in a dashboard's list?

I have a list with well over 100 attributes, but to make the list a little more compact and easier to read, I'd like to only display the feature's attributes that are not null.

This:

Attribute 1: Yes
Attribute 3: Yes
Attribute 6: Yes

vs. this:

Attribute 1: Yes
Attribute 2:
Attribute 3: Yes
Attribute 4:
Attribute 5:
Attribute 6: Yes

Re: Only display not null attribute values in list?

Alber_Verster — Sun, 22 Nov 2020 22:25:13 GMT

Hi Jason,

Yes there is. During the configuration of the List tool in Dashboard, in the Filter section select the field you wish to filter by and then choose "is not null" in the operator's field. This will filter out all values that are null in the List only.

Hope his helps.

Alber

Re: Only display not null attribute values in list?

JasonCyphers — Mon, 23 Nov 2020 10:48:45 GMT

Thanks for the reply; however, I don't think that will work in my situation.

Applying that filter will filter out the features, I just want to filter out attributes that are null.

My list currently looks like this:

Feature 1

Attribute 1: Yes
Attribute 2:
Attribute 3:
Attribute 4: Yes
Attribute 5:
Attribute 6:
Attribute 7:
Attribute 8: Yes
Attribute 9:
Attribute 10:

I want to exclude the attributes that are null, so the list is a little shorter and easier to read, like this:

Feature 1

Attribute 1: Yes
Attribute 4: Yes
Attribute 8: Yes

Re: Only display not null attribute values in list?

Alber_Verster — Mon, 23 Nov 2020 22:10:26 GMT

Hi Jason,

So you're looking for more of a dynamic filter type.

Will the same attributes always have values or is there no consistency or pattern to the populated fields?

Based on the responses of Derik Law in this thread, you would not be able to incorporate IF, ELSE statements or make use of Arcade yet but this is apparently on the roadmap.

https://community.esri.com/t5/arcgis-dashboards-questions/source-code-for-list-element-in-operations-dashboard/td-p/740444

Regards

Alber

Re: Only display not null attribute values in list?

JasonCyphers — Tue, 24 Nov 2020 11:01:41 GMT

Correct. Field Crews utilize Survey123 to select a job they are performing and then select from a number of hazards, control mechanisms, etc. associated with the job. It's a looong list to display in a dashboard, so I'm trying to shorten it some.

I want the list to go from this:

Feature 1

Attribute 1: Yes
Attribute 2:
Attribute 3:
Attribute 4: Yes
Attribute 5:
Attribute 6:
Attribute 7:
Attribute 8: Yes
Attribute 9:
Attribute 10:

Feature 2

Attribute 1: Yes
Attribute 2: Yes
Attribute 3:
Attribute 4: Yes
Attribute 5:
Attribute 6: Yes
Attribute 7:
Attribute 8: Yes
Attribute 9:
Attribute 10:

to this:

Feature 1

Attribute 1: Yes
Attribute 4: Yes
Attribute 8: Yes

Feature 2

Attribute 1: Yes
Attribute 2: Yes
Attribute 4: Yes
Attribute 6: Yes
Attribute 8: Yes