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 new export lands in your inbox and everyone wants the report today, with no way to know yet if a single number in it is real.
What you'll have at the end
A written pass or fail on row count against a known total and a few spot-checked values.
You need
A newly arrived export you have not opened yet, and read access to wherever it came from so you can look up its total independent of the file itself.
Not covered
Building a rule that runs this same check automatically on every future load without anyone watching it.
Write a validation rule that flags a total gone wrong
once a count-and-compare check like this one is worth running every time, turning it into a saved rule instead of a one-off is the next move.
Catch a join fan-out that doubles your totals
when the overcount is close to double the anchor rather than a handful of stray rows, a join fan-out is the likelier cause, and that gets its own diagnosis.
Checked 26 Aug 2026
Part of the Data Cleaning and Validation for Analysts cookbook