Insights - How to Filter for N/A Values

Updated 1 year ago by Elena Yurkova

How to filter for N/A values

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

  1. Go to List deselect all first and after pick N\A:
  2. Now, go to Advanced option and add a comma after "N\\A" followed by null:

"members": [

"N\\A",

null

]

  1. Click on 'Test' to see if the new filter gives you expected values.

How to apply N/A together with other list items

  1. Start by deselecting all items add picking only the items you need (note: do not select N/A in this step)
  1. Next, go to Advanced and add after the last item:

,

"N\\A",

null

  1. Click on 'Test' to see if the new filter gives you expected values.


How did we do?