Most organisations have experienced it: two reports, two numbers, and a meeting spent working out which is right. The instinct is to build a better dashboard. The real fix is usually upstream.
Why numbers disagree
Metrics drift apart for predictable reasons. Teams filter data differently, count at different points in a process, refresh on different schedules, or quietly adjust a formula in their own copy of a report. None of these are mistakes in isolation, but together they make a single figure impossible to trust.
Step 1: write the definition down
For each headline measure, record a plain-English definition, the exact calculation, the source system, who owns it and how often it refreshes. A short metric glossary that people can find is worth more than an elegant one nobody reads.
Step 2: give each metric an owner
Every measure needs a named owner who can approve changes. That owner is usually in the business, not in IT, because they understand what the number is meant to represent.
Step 3: calculate it once
Put the agreed calculation in a shared semantic model or data layer, and build reports on top of it. When the definition lives in one place, every report that uses it changes together.
Step 4: reconcile, then publish
Before retiring old reports, reconcile the new figure against the previous ones and explain any differences. People accept a change much more readily when they understand why the number moved.
Step 5: keep it agreed
Review definitions when processes change, and make the glossary part of onboarding for anyone who builds reports. Agreement is not a one-off project; it is a habit.
If your organisation is stuck debating numbers, our business intelligence and reporting service can help you get to a single, trusted set of measures.