Hide Null or 0 values in table

dwold — Thu, 22 Feb 2024 14:07:31 GMT

I want to remove/hide records that have Null or 0 in a table. I'd like the Gap Percent column to start with the Gap Percent record that has 5. @KenBuja I saw a thread on doing this in pop-ups that I tried to follow but having some issues getting it to work in a table.

I tried something like this, and it removes the Null values but not the 0 values as well:

var gap = IIf(IsEmpty($datapoint.gap_percent), "0", $datapoint.gap_percent) return { cells: { target_value_final: { displayText : $datapoint.target_value_final, textColor: '', backgroundColor: '', textAlign: 'right', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, gap_percent: { displayText : gap, textColor: '', backgroundColor: '', textAlign: 'right', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' } } }

Re: Hide Null or 0 values in table

KenBuja — Fri, 23 Feb 2024 17:57:35 GMT

IsEmpty returns true if a field either has a null value or an empty string (''). You'll have to check separately for the 0 value, since that is not null.

var gap = IIf(IsEmpty($datapoint.gap_percent) || $datapoint.gap_percent == 0, "0", $datapoint.gap_percent)

Re: Hide Null or 0 values in table

dwold — Mon, 26 Feb 2024 13:49:21 GMT

@KenBuja thank you!!!

topic Re: Hide Null or 0 values in table in ArcGIS Dashboards Questions

Hide Null or 0 values in table

Re: Hide Null or 0 values in table

Re: Hide Null or 0 values in table