Your Pipeline Dashboards Are Lying to You — Here's How to Fix Them

Your VP of Sales asks for the pipeline number on Monday morning. The sales manager pulls a report and says $2.4M. A rep checks their dashboard and says $1.8M. Someone pulls a spreadsheet from last Friday and says $2.1M.

Three people. Three numbers. Same Salesforce instance.

This happens in roughly 80% of the orgs we work with. And the root cause is almost never "Salesforce is broken." The root cause is that nobody architected the reporting layer — dashboards were built ad hoc by different people with different filter logic, different date ranges, and different assumptions about what counts as "pipeline."

Here's how to fix it. Not with theory — with the exact dashboard configurations that produce one number everyone trusts.

Why Your Current Dashboards Don't Work

Most pipeline dashboards fail for one of three reasons:

1. No standardized filters. One dashboard shows "This Quarter," another shows "Next 90 Days," another shows "This Quarter + Next Quarter." The pipeline numbers are different because the time windows are different — but nobody realizes that's why.

2. Inconsistent stage inclusion. Some dashboards include Closed Won deals in the pipeline total (inflating the number). Others exclude Closed Lost but include deals from 8 months ago that are clearly dead. Without explicit stage filters, the numbers drift.

3. Running user visibility. Salesforce dashboards show data based on the "running user" — the user whose data permissions determine what appears. If the dashboard runs as a rep, it shows only their deals. If it runs as an admin, it shows everything. Two people looking at the same dashboard can see different numbers if this isn't configured correctly.

The fix for all three is the same: build one source of truth with explicit, locked-down filters and make it the only pipeline dashboard anyone references.

The 5 Dashboards Your Sales Org Actually Needs

You don't need 15 dashboards. You need 5. Each answers a specific question your leadership asks regularly.

Dashboard 1: Pipeline by Stage (The Daily Check)

This is the dashboard your VP looks at every morning. It answers: "What does our pipeline look like right now, and is it enough to hit our number?"

Components:

• Pipeline Value by Stage — Horizontal bar chart. Source: Opportunities report. Group by Stage. Sum of Amount. Filter: Close Date = THIS QUARTER or NEXT QUARTER. Stage NOT IN (Closed Won, Closed Lost). This is the centerpiece.
• Pipeline Count by Stage — Donut chart. Same source and filters. Shows deal COUNT, not dollar value. This reveals whether your pipeline is concentrated in a few big deals (risky) or spread across many (healthier).
• Pipeline by Owner — Stacked bar chart. Same filters. Group by Owner, then Stage. Shows each rep's pipeline broken out by stage. Immediately reveals who has pipeline and who doesn't.
• New Pipeline This Month — Single metric. Filter: Created Date = THIS MONTH. Shows how much new pipeline was generated. If this number is declining month over month, you have a lead generation problem.
• Weighted Pipeline — Single metric. Sum of (Amount × Probability). This is your forecast number. If your stages have accurate probabilities assigned, this metric is more reliable than any spreadsheet forecast.

Configuration notes: Set the Running User to someone with visibility into ALL Opportunities — typically the VP of Sales or a dedicated reporting user. Enable Scheduled Refresh: daily at 6am. Pin this dashboard to the home page for the Sales profile so it's the first thing the team sees when they open Salesforce.

Dashboard 2: Conversion Rate Analysis (The Weekly Review)

This answers: "How efficiently are we converting pipeline to revenue?"

• Stage-to-Stage Conversion Rate — Funnel chart or horizontal bar. Shows what percentage of deals advance from each stage to the next.
• Conversion by Source — Grouped bar chart. Conversion rate broken out by Lead Source. Tells you which channels produce pipeline that actually closes vs. pipeline that stalls.
• Average Deal Size by Stage — Bar chart. Do deals shrink as they advance? If the average Amount in Proposal is lower than in Qualification, reps are discounting to advance deals.
• Win Rate Trend — Line chart. Monthly win rate (Closed Won / (Closed Won + Closed Lost)). Trending down? Something systemic is happening.

Dashboard 3: Stalled Deal Tracker (The Pipeline Hygiene Check)

This answers: "Which deals are dying and nobody is doing anything about it?"

In most orgs, 30–40% of open pipeline has gone dark — no activity in 14+ days — and nobody notices because there's no visibility.

You need a custom formula field first. Go to Setup → Object Manager → Opportunity → Fields & Relationships → New. Create a formula field:

• Name: Days_Since_Last_Activity
• Type: Number
• Formula: TODAY() - LastModifiedDate

Components:

• Stalled Deals Table — Report table showing all Opportunities where Days_Since_Last_Activity > 14 AND Stage NOT IN (Closed Won, Closed Lost).
• Stalled Deals by Owner — Bar chart. Count of stalled deals per rep. This is the accountability view.
• Stalled Pipeline Value — Single metric. Total Amount of all stalled deals. This number represents revenue at risk of being lost silently.

Dashboard 4: Rep Performance (The Coaching Tool)

This answers: "How is each rep performing relative to their peers and their targets?"

• Pipeline by Rep vs. Target — Grouped bar chart. Each rep's current pipeline compared to their quota.
• Activities by Rep — Bar chart. Calls, emails, meetings logged per rep per week.
• Average Sales Cycle by Rep — Bar chart. Average days from Opportunity creation to Closed Won per rep.
• Win Rate by Rep — Bar chart. Closed Won / total closed per rep.

Dashboard 5: Forecast vs. Actual (The Accountability Mirror)

This answers: "How accurate was our forecast, and are we getting better at predicting?"

• Quarterly Forecast vs. Actual — Bar chart. Side by side comparison of what was forecasted at the start of each quarter vs. what actually closed.
• Forecast Accuracy Trend — Line chart. Monthly forecast accuracy percentage over time. Should be trending toward 85%+ accuracy.
• Over-Forecast vs. Under-Forecast by Rep — Table. Shows which reps consistently over-forecast vs. under-forecast.

The 30-Minute Quick Start

1. Build Dashboard 1 (Pipeline by Stage) — 10 minutes. This single dashboard replaces the Friday spreadsheet.
2. Create the Days_Since_Last_Activity formula field — 2 minutes.
3. Build the Stalled Deals report — 5 minutes. Filter: Days_Since_Last_Activity > 14, open deals only.
4. Create a Stalled Deal Alert Flow — 10 minutes. Scheduled daily, emails the Owner when a deal goes stale.
5. Pin Dashboard 1 to the home page — 3 minutes.

The Mistakes Everyone Makes

Building dashboards nobody checks. If the dashboard isn't pinned to the home page and referenced in meetings, it doesn't exist. Build it, pin it, talk about it.

Too many components. Each dashboard should answer 2–3 questions. If you're cramming 12 components onto one dashboard, split it into two.

Using "Created Date" instead of "Close Date." Pipeline reports should always filter on Close Date. This is the #1 reason pipeline numbers don't match expectations.

Not standardizing the Running User. Set it to a user with full Opportunity visibility. Document this in the dashboard description so future admins know why.