Interactive table filter - returning all results when expected to filter out results with non-NULL/blank field values

[kkl]

Hello,

I am trying to filter a table to show only records without a value in a field called “grouping.” My table filter is:

The “filter_grouping” variable is populated via single-select dropdown which has an aggregation as a datasource:

When I select the blank option in the dropdown, records with non-blank values in “grouping” are returned:

However, I only want records without values in this field to be returned. Is it possible?

[ta-aoki]

I am guessing that the the third value of your dropdown list to enter the filter_grouping variable is null.

If you change null to empty string, you get the expected result.

At least that was how my test App behave.
app.json (7.9 KB)

(Although I don’t understand why equal to null filter is showing every record…)

[ta-aoki]

I guess what you are seeing is the same with Case 1 in Aggregation sum give 0 when empty