Only display not null attribute values in list?

2008
4
11-22-2020 04:00 AM
JasonCyphers
Occasional Contributor III

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
Tags (2)
0 Kudos
4 Replies
Alber_Verster
Esri Contributor

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.

 

Capture1234.PNG

 

Hope his helps.

 

Alber

JasonCyphers
Occasional Contributor III

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
Alber_Verster
Esri Contributor

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...

Regards

Alber

 

JasonCyphers
Occasional Contributor III

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
0 Kudos