Compare the reports' data sources, fields, filters and breakdowns before attempting to consolidate their information, using HubSpot guidance.
Key takeaways
- Before the forecast call, list the data sources, fields, filters, and breakdowns for each conflicting report.
- Align the opportunity cohorts you are comparing.
- Inspect the report controls that shape the output.
Sales dashboard discrepancies: the investigation steps
Before consolidating conflicting dashboard figures, list the specific configuration inputs for each report. To consolidate information, create a new custom report that includes the relevant data sources, fields, filters, and breakdowns, according to HubSpot.
Start by identifying the underlying report sources for each conflicting view. Do not assume that two dashboards pulling from the same CRM account display the same population of records. Each report may include different data sources, fields, filters, and breakdowns that change the total amount shown.
Record the data sources selected in each report. Note the specific fields used for calculations, such as deal amount or quantity. List every filter applied, including date ranges, stage statuses, and owner assignments. Document the breakdowns used, such as grouping by team, product, or time period.
Create a side-by-side comparison of these inputs. When you see a discrepancy, check whether the reports use the same data sources, fields, filters, and breakdowns. If the inputs differ, the totals will differ. This comparison identifies which configuration setting causes the variance before you investigate individual deal records.
Use the custom report builder to test a consolidated view if needed. This step confirms whether the discrepancy comes from report configuration or from the underlying data.
Identify the sources, fields and breakdowns being compared
Before you compare the totals on two conflicting dashboards, list exactly what each one is pulling. A discrepancy often comes from the reports using different inputs rather than from bad deal data. Start by naming the data sources behind each report. With the custom report builder, you can analyze multiple data sources across HubSpot, according to HubSpot. This means you must check whether one dashboard is reading from a single object while the other is combining several. If the sources differ, the totals will not match even if the underlying records are identical.
Next, list the specific fields each report is summing or counting. A report that totals the deal amount will produce a different number than one that counts the number of opportunities. Write down every field used in the calculation for both reports. If one report includes a field the other excludes, the gap is explained by that missing input. You do not need to fix the data yet; you only need to confirm which fields are actually in play.
Then, document the filters applied to each view. Filters narrow the population of records included in the total. If one report filters for a specific stage and the other does not, the smaller total is expected. Record every filter condition, including any date ranges or status values. This step reveals whether the reports are looking at the same group of deals or different slices of the pipeline.
Finally, note the breakdowns used in each report. A breakdown splits the total into subgroups, such as by team or region. If one report breaks down by rep and the other does not, the way you read the total changes. List the breakdown dimensions for both reports so you can see if they are aggregating the same data in different ways.
Align opportunity cohorts, expected dates and category scope
Before comparing totals from different dashboards, verify that the underlying opportunity populations use the same definition of time. A report showing deals active during a specific period may include opportunities created months earlier, while another report might only count deals created within that same window. In the Opportunity Funnels Report, you can view opportunities that were active during that time period, regardless of when they were created, by selecting the "Was Active, Won or Lost" option according to Close. If you want to view opportunities that were created during a specific time period only and were active during another date range, the "Was Created" option is available according to Close. These distinct cohort definitions mean that two reports covering the same calendar month can legitimately display different deal counts if one uses activity-based logic and the other uses creation-based logic.
Next, examine how the reports segment deals by their expected closing timeline. In Freshsales, you can use the deal timeline view to segment deals based on the expected closed date according to Freshsales. If one dashboard groups deals by the month they are expected to close and another groups them by the month they entered a specific stage, the resulting totals will not align even if the underlying data is identical. Confirm whether the view you are comparing against uses the expected closed date as its primary segmentation axis before attempting to reconcile the numbers. See the close date change log.
Finally, inspect the confidence category assigned to each opportunity, as this value dictates where the deal appears in forecast views. When you create or edit an opportunity, set its Forecast Category to reflect your current confidence in closing it according to Microsoft. This value determines which column the opportunity appears in on the forecast grid according to Microsoft. If a recent update changed the forecast category of several deals, those deals will shift between forecast grid columns, altering the totals displayed in any report that aggregates by forecast category. Review the current confidence selection for the deals in question to ensure they are placed in the intended forecast column. See Pipeline, Best Case, Commit: Forecast Categories Explained.
Inspect filters, display ranges and report limits
When two dashboards show different totals, the discrepancy often hides in the report controls rather than the deal data. Check the specific limits and filter logic applied to each view before assuming the underlying numbers are wrong.
In the custom report builder, you can add a maximum of 12 fields to the X-axis and one to the Y-axis for a horizontal bar chart, or one field each to the X and Y axis and one Break down by, according to HubSpot. Verify that the chart type and field count match the intended comparison scope.
For fields with no aggregation type, set a limit to the number of values added to the report from this field, such as Top 10 or Bottom 20, according to HubSpot. This limit controls how many distinct values appear in the report. If one dashboard shows a "Top 10" list and another shows an unfiltered total, the totals will not match because the first report excludes values beyond the limit. Confirm whether the limit is active and what value it holds.
Boolean filter logic also shapes the population included in a report. For example, entering 1 and (NOT 2) will include data that adheres to filter 1 but not to filter 2, according to HubSpot. If one report uses a negative filter to exclude a specific stage or owner, its total will be lower than a report without that exclusion. Review the filter syntax to ensure both reports apply the same inclusion and exclusion rules. See weekly deal review filters.
Axis settings can change how values appear without changing the underlying data. For example, a value of 100 on a vertical bar chart will set the Y-axis to display up to a value of 100, according to HubSpot. Similarly, a value of 50 on a vertical bar chart will set the Y-axis to start at a value of 50, according to HubSpot. These settings affect the visual range of the chart. If one chart starts at 0 and another starts at 50, the bars will look different even if the data is identical. Check the axis floor and ceiling settings to ensure the visual representation matches the intended comparison.
Event volume restrictions can also shorten the available time frame. If there are over 10 million events (Professional only) or 100 million events (Enterprise only) for the selected event type, the available time frame will be shortened, according to HubSpot. This restriction applies specifically to the event volume thresholds for the selected plan. If one report covers a shorter time period due to high event volume, its total will be lower than a report covering the full period. Verify the time frame applied to each report and note any shortening caused by event volume limits.
Report control reference table by publisher
The table below lists four documented report controls, one from each publisher, to help you verify which settings affect your dashboard totals before the forecast call.
| Publisher | Report Control or Rule | Documented Detail |
|---|---|---|
| HubSpot | Custom report builder sources | With HubSpot's custom report builder, you can analyze multiple data sources across HubSpot, according to HubSpot. |
| Close | Active opportunity cohorts | You can view Opportunities that were active during that time period - regardless of when they were created - by selecting Was Active, Won or Lost, according to Close. |
| Freshsales | Deal timeline segmentation | Use the deal timeline view to segment their deals based on the expected closed date, according to Freshsales. |
| Microsoft | Forecast category confidence | When you create or edit an opportunity, set its Forecast Category to reflect your current confidence in closing it, according to Microsoft. |
Check these four controls in your respective tools to confirm the scope of each report.
Keep the comparison settings and report repair decision
Once you have compared the data sources, fields, filters, and breakdowns of the conflicting reports, you must decide how to handle the discrepancy in your dashboard setup. A common misconception is that two separate reports can be combined into a single view to resolve conflicting totals. However, existing reports can't be merged into a single report, according to HubSpot. This limitation means you cannot simply consolidate two distinct report configurations into one unified report to force the numbers to align.
If you have the necessary permissions but find that the data still cannot be combined into a single report, you have two primary paths forward. First, you can consider simplifying the metrics, using available datasets where applicable, or keeping the reports separate on a dashboard, according to HubSpot. This approach accepts that the reports will remain distinct and focuses on making the individual metrics clearer rather than forcing a total. Second, you can create a new report with the relevant inputs if the existing reports are missing a critical field or filter that causes the discrepancy.
Illustrative example of two dashboard totals
A weekly review compares two totals for the same pipeline. The first total is 100. The second total is 50. The gap is 50, which is half of 100. The first view sums every open row in the week. The second view keeps only the top 10 rows and starts the chart axis at 50, so the picture looks smaller even when the rows overlap. A third check counts 4 breakdown groups on one view and 2 on the other. Because 4 groups are not the same set as 2 groups, the 100 and the 50 answer different questions. Keep both figures side by side, label which inputs each one uses, and bring that note to the forecast call. Do not force the 100 and the 50 into one number until the inputs match.
Action step: Check your report permissions and decide whether to create a new report with aligned inputs or keep the existing reports separate on your dashboard.
FAQ: investigating conflicting sales dashboard figures
How do I investigate sales dashboard discrepancies?
Compare the reports' data sources, fields, filters, and breakdowns before attempting to consolidate their information. This approach ensures you are analyzing the same underlying inputs rather than assuming the totals should match.
What is the difference between Was Active and Was Created in Close?
The "Was Active" option shows opportunities that were active during a time period regardless of when they were created, according to Close. The "Was Created" option shows opportunities created during a specific time period and active during another date range, according to Close. Using the wrong cohort definition can make totals appear inconsistent when the underlying populations differ.
Does HubSpot shorten event report time frames on my Professional or Enterprise plan?
Yes, if there are over 10 million events for the selected event type on a Professional plan, the available time frame will be shortened, according to HubSpot. On an Enterprise plan, the time frame shortens if there are over 100 million events for the selected event type, according to HubSpot. Check your event volume before assuming a missing date range indicates missing data.
Can I merge existing HubSpot reports into one report?
No, existing reports can't be merged into a single report, according to HubSpot. You must check report permissions and then create a new report with the relevant inputs, according to HubSpot. Alternatively, you can simplify the metrics and retain separate dashboard reports, according to HubSpot.
How does an opportunity's forecast category affect its forecast-grid column?
A change in the forecast category moves the opportunity to a different column, altering the total for that specific grid section.