New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
A report's row count comes up short, because a comparison filter quietly drops any row where the column it's testing is blank.
What you'll have at the end
A rewritten filter that keeps the NULL rows on purpose, with the row count checked before and after
You need
A report query with a WHERE comparison on a column that has genuinely blank values in some real rows, not typos, and a database you can run counting queries against.
Not covered
Filtering a column that arrives through a LEFT JOIN, where the same blank-value behavior can quietly turn the join itself into an inner join. That needs its own fix inside the join condition, not the WHERE rewrite covered here.
Leans on
Checked 26 Aug 2026
Part of the SQL for Data Analysis cookbook