How do you filter rows by removing the non empty rows?

[Yousuf Al Rawahi]

In eazybi report, I have a table with two columns, Object (telephone number) and Telephone List Owner. In the second column (Telephone List Owner), some of them are not assigned (empty). How do you filter rows by removing the non-empty rows?

I just want the empty rows.

[Roberts Čāčus · Accepted solution]

Hi @Yousuf Al Rawahi

If the second column is a property selected from Measures, you can filter report rows to match any non-empty value. Please see the screenshot below:

In the dialog, specify the regular expression "." - a dot. The result could look similar to the one below:

Best,
Roberts // support@eazybi.com

[Yousuf Al Rawahi]

But I want the empty rows only, if possible.
I'm trying to view a table in eazybi of unassigned telephone numbers.

Thanks

[Roberts Čāčus]

Hi @Yousuf Al Rawahi

I apologize for confusing your requirement. To view only empty ones, use the not matches option instead of matches.

Best,
Roberts // support@eazybi.com

[Yousuf Al Rawahi]

It worked. Thanks!