GIS Dashboard -- Table -- Null values

staciemaya

Please help. I would like to edit the code below so that cells in my table that have null values will show the word "Missing" rather than be blank. 

I assume it is this line that needs to change. "numsurcharge" is the column that occasionally has blank information that I would like to clearly identify with the word "Missing." 

displayText : Text($datapoint.numsurcharge),

Thank you! 

 

Arcade Expression for Table in GIS Dashboard: 

return {

cells: {

name: {

displayText : $datapoint.name,

textColor: '',

backgroundColor: '#ffffff',

textAlign: 'center',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

},

 

numsurcharge: {

displayText : Text($datapoint.numsurcharge),

textColor: '',

backgroundColor: '#ffffff',

textAlign: 'center',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

},

 

currentrenteffdate: {

displayText : Text($datapoint.currentrenteffdate),

textColor: '',

backgroundColor: '#ffffff',

textAlign: 'center',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

},

 

}

MiaWhite34

 

You can modify your Arcade expression to display “Missing” whenever the numsurcharge field is null (or empty). In Arcade, you can use a conditional (IIf) to check the value. Here's the updated snippet for your numsurcharge cell:

 

 

numsurcharge: { displayText: IIf(IsEmpty($datapoint.numsurcharge), "Missing", Text($datapoint.numsurcharge)), textColor: '', backgroundColor: '#ffffff', textAlign: 'center', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' },

✅ Explanation:

• IsEmpty($datapoint.numsurcharge) checks if the value is null or empty.

• IIf(condition, trueValue, falseValue) returns "Missing" if the field is empty; otherwise, it returns the actual value converted to text.

  This will ensure that any blank cells in numsurcharge now display “Missing” in your GIS Dashboard table.

•