Why does every report show a different number, and how do you fix it?

The short answer

Reports disagree because each export applies its own filters, timing and logic. The fix is to agree on one definition per measure, compute it from the system of record, and let every figure open to the records behind it. Meetings then start from the same facts instead of a debate about whose number is right.

Why the numbers drift

Each report is pulled at a different time, with different filters, and often with hand edits along the way. Copies of the spreadsheet multiply. Two people can both be right about their own version of the number and still disagree.

It gets worse as the business grows: more systems, more spreadsheets, more versions. Nobody can see what is behind a figure without redoing the work, so the meeting spends its time on the number instead of the decision.

What it takes

  • One shared definition per measure, agreed with your team and written down once.
  • The measure computed from the system of record, read-only, instead of from a copy of an export.
  • A drill-down on every figure, so anyone can see the records behind it.
  • The same definitions behind every dashboard and every answer the assistant gives.

Agreeing definitions is the slow part, and it is worth doing once. A definition that is written down can be checked, changed on purpose, and applied the same way next month.

Your data, and what it means, belong to you. We bring the tools that apply your definitions everywhere your team looks.

What changes

Leaders get a coach’s scoreboard: the live picture across the operation, so coaching conversations start from the same facts. Each team gets a player’s scoreboard: the few numbers it controls, simple enough to act on today. Both come from the same definitions, which is what makes the analytics trustworthy.

In our plant controller case study, a question about a figure is now answered by drilling into it, instead of by rebuilding the report. In the production reporting case study, one step applies the same rule across the whole week, and operations reviews the exceptions instead of doing the arithmetic.

Related questions

Who decides the definition?

Your team does. We write each definition down with you and apply it everywhere the measure appears.

Do we need to replace our systems?

No. Your existing systems stay the system of record. We add answers on top, without creating a competing master record.

Where do we start?

With one measure that causes the most debate today. Once its answer earns trust, we take on the next one.

More answers · All case studies

Start with one decision.

Tell us the question you cannot answer today. We will tell you honestly whether your data can support an answer.

Start a conversation