Business case: you have a table User-Define field; but some records have no values in this field and you would lie to filter your dashboard to see only the records with the missing values.
To filter on N/A only or to include N/A as one of the items; you must use the Advanced filtering option.
How to apply N/A filter to select only data without values
Go to List deselect all first and after pick N\A:
Now; go to Advanced option and add a comma after "N\\A" followed by null:
"members": [
"N\\A";
null
]
Click on 'Test' to see if the new filter gives you expected values.
How to apply N/A together with other list items
Start by deselecting all items add picking only the items you need (note: do not select N/A in this step)
Next; go to Advanced and add after the last item:
;
"N\\A";
null
Click on 'Test' to see if the new filter gives you expected values.
