Filtering null values

[miri]

Hello,

I have fields of user, and record creation date, and count.

I applied conditional formatting to this table to highlight null values.

I now want to filter this by only month September 2020, but all the filters I apply remove the null values, since I can only filter by creation date. Is there a way I can filter to achieve the full set of results, so that for example user Alga doesn't disappear from the table when I try to keep all September dates?

I basically want to filter by current system date rather than the date used when creating the table.

Thank you!

[flamber]

Hi @miri
You would need to create another question, which returns all the users, and then join in this question, so it always returns all users.
I'm not sure I fully understand how you data is structured, but database will only return results based on how you're filtering.