Sales says Q3 bookings were $4.2M. Finance says $3.9M. Both numbers come from a dashboard, and both dashboards are "right." The meeting that follows isn't about the business. It's about whose number to trust.
The Chart Isn't the Problem
Tableau, Power BI and Looker all draw the same bars. When two reports disagree, the cause is almost never the visualization. It's that each report carries its own logic for what counts:
- Bookings vs. revenue. One report uses close date. The other uses invoice date.
- Currency and FX. One converts at deal creation, the other at month-end close.
- Credits and amendments. One nets them out. The other ignores them until finance posts the entry.
- Owner and territory. A rep change mid-quarter moves the deal in one view and not the other.
Each calculation lives in a workbook some analyst built two years ago. Nobody owns it, and nobody remembers why it differs.
Why It Gets Worse Over Time
Every new dashboard copies the nearest calculated field and tweaks it. Six months later you have four versions of "Net New ARR." Ad-hoc requests pile up because nobody trusts the standing reports enough to stop asking for a custom pull. The analyst becomes a human reconciliation layer.
A Fix That Holds
- List your top ten metrics. Bookings, pipeline, win rate, churn, net new ARR, cost of sale. Start with the ones that show up in board decks.
- Write one definition for each. Source system, date field, inclusions, exclusions, currency rule. One paragraph, no ambiguity.
- Name an owner. Finance owns anything that ties to the ledger. RevOps owns pipeline and stage metrics. The owner approves changes, not whoever builds the next workbook.
- Move the logic upstream. Put the calculation in the warehouse or a published Tableau data source, not in individual workbooks. Dashboards consume the metric. They don't redefine it.
- Add a reconciliation check. A scheduled query compares the dashboard total to the system of record and flags drift above a set tolerance. You hear about a mismatch before the exec team does.
- Retire the duplicates. Tag every legacy workbook that uses a non-standard calculation, then archive it or repoint it. Leaving them live defeats the exercise.
What Good Looks Like
You know it's working when a rep, a controller and a VP of Sales can each open a different view and get the same figure to the dollar. Month-end close stops including a "why don't these tie" step, and drill down from a total lands on records anyone can verify. That's what a source of truth means in practice.
Our Take
Teams often respond to conflicting numbers by buying another tool or rebuilding the dashboard. Neither helps if the definitions stay vague. Spend the first week on the ten definitions and the owners. The rebuild afterward is the easy part. If you want a second set of eyes on where your numbers diverge, we'll trace each metric from source to dashboard and show you exactly where the split happens.