nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Roberts Čāčus - eazyBI

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:

Screenshot 2024-03-19 at 17.32.19.png

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

Screenshot 2024-03-19 at 17.32.30.png

Best,
Roberts // support@eazybi.com

All comments

Roberts Čāčus - eazyBI

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: