Skip down to the research record

Funnel chart totals: 3 metrics and why deals repeat

Quota Forecast Editorial Team · Published · 10 min read

A funnel total can count one deal in several stages, so the sum of columns does not equal the deal count. Close documents this behavior in its Opportunity Funnels Report. Because a single opportunity appears in multiple stages as it moves through the pipeline, it gets counted again in each new column. The column total can therefore be higher than the number of unique opportunities.

Key takeaways

Before you read a total in a funnel report, identify which of the three column types it represents. The Opportunity Funnels Report in Close defines these distinct metrics for each stage.

  • Count

    • This column shows the number of opportunities in each status.
    • It is a simple tally of deal records, not a dollar amount.
  • Value (Annualized)

    • This column displays the annualized value of your opportunities.
    • It sums the deal amounts, adjusted for annual billing cycles.
    • It does not account for the likelihood of closing the deal.
  • Weighted Value (Annualized)

    • This column takes the annualized opportunity values and multiplies them by their confidence percentage.
    • It reflects the probability-adjusted value of the pipeline.
    • It is the metric to use when forecasting revenue based on opportunity confidence percentages.

One deal can be counted in more than one column of a funnel

Close states that each opportunity appears in many stages, so it can be counted multiple times in the funnel report. This is not a bug or a data error; it is how the visual structure works. A deal that starts in Stage 1 and moves to Stage 2 exists in both columns simultaneously. If it then moves to Stage 3, it now appears in three columns. The report reflects the journey, not just the current status.

When you look at a funnel chart, the width of each bar represents the count or value in that specific stage. If you have ten open opportunities, five in Stage 2 and five in Stage 3, and all ten passed through Stage 2, the funnel shows ten in Stage 2 and five in Stage 3. Adding those two columns gives more than the ten unique opportunities. This distinction matters when you present numbers to a team or a board. If you say "we have more than ten opportunities," you are overstating the unique count. If you say "the funnel total is more than ten," you are describing the sum of the two stage columns.

Funnel count rules by publisher in one table

Each vendor documents its funnel or stage metric differently, so the total column reflects a specific calculation rather than a universal standard. The table below maps each publisher's documented definition to the context where it appears.

PublisherFunnel/Stage Metric DefinitionSource Context
PipedriveWeighted value calculated as total value times deal probability divided by 100Probability in Pipedrive
NutshellToggle between quantity and value of leads in the sales funnelReporting: An overview of Nutshell reports
FreshsalesNumber of deals and sum total of deals' value in each stageDeals : Table and Card views : Freshsales
CloseCount, value (annualized), and weighted value (annualized) for each statusOpportunity Funnels Report

The definitions above show that a funnel column is not automatically a simple count of unique opportunities. Pipedrive defines a weighted value by multiplying the total value by the deal probability divided by 100, which means the column holds a calculated dollar figure rather than a raw count. Nutshell allows users to toggle between quantity and value of leads in the sales funnel, indicating that the same visual chart can display either a count or a sum depending on the selected view. Freshsales describes finding the number of deals and the sum total of the deals' value in each stage, so both metrics are documented.

Because these definitions vary, a total that looks like a count in one tool might be a weighted sum in another. When you read a stage report, check the column header or the help documentation to see if the tool is summing values, counting records, or applying a probability multiplier. If the column is labeled "Weighted" or includes a probability percentage, it is likely a calculated value rather than a simple deal count. If the column allows a toggle between quantity and value, you must verify which mode is active before quoting the number. This distinction matters because a weighted sum can be lower than the total pipeline value, while a simple count ignores deal size entirely. To see how mismatched totals arise, read Forecast total mismatches: 4 calculation mistakes to check.

To avoid misreading the total, compare the column definition against the specific vendor's documentation. If you are using a tool that offers multiple report views, confirm which view is currently selected. If the report includes both a count and a value column, treat them as separate metrics that answer different questions. The count tells you how many opportunities exist in that stage, while the value tells you what those opportunities are worth. A weighted value tells you what those opportunities are worth if you apply the current probability of closing.

Count, annualized value, and weighted value are different columns

The Opportunity Funnels Report in the Close Help Center defines three distinct metrics for each status column. The first is the count, which Close describes as "The Number of Opportunities in each Status." This column counts the opportunities the report associates with each status, and one opportunity can appear in more than one stage column. It does not sum dollar amounts or apply probability multipliers. When you read this number, you are looking at a simple tally of records.

The second metric is the annualized value. The same source defines this as "The Annualized Value of your Opportunities." This column converts deal values into an annual figure before summing them. It reflects the total potential revenue if every deal in that stage closed at its annual rate. It remains a sum of values, not a count of deals, and it does not adjust for the likelihood of closing.

The third metric is the weighted value. Close defines this as "The Opportunity Values Annualized, multiplied by their Confidence Percentage." This calculation takes the annualized value and reduces it by the confidence level assigned to the opportunity. The result is a probability-adjusted figure that reflects the expected value of the pipeline. Because it multiplies the value by a percentage, the weighted total will always be lower than or equal to the annualized value for the same set of deals.

Pipedrive uses a similar weighted calculation but applies it under specific conditions. According to Pipedrive, the formula applies "When both deal and stage probabilities are set." The calculation is "[Total value] x [deal probability/ 100] = Weighted value." For a field-level check of weighted amounts, see Weighted deal amount: 5 fields to check HubSpot, Pipedrive.

Understanding the difference between these three columns prevents misinterpretation of funnel totals. A count column answers how many deals are in a stage. An annualized value column answers what those deals are worth per year. A weighted value column answers what those deals are worth after adjusting for confidence. Mixing these up leads to incorrect pipeline assessments. For example, treating a weighted value as a raw count ignores the probability adjustment. Treating an annualized value as a weighted figure ignores the confidence multiplier.

A short process on the help page is not a required stage count

The Working with Opportunities page in the Copper Help Center states that your process could be simple, having only 3 stages of pipeline from Identified to Closed, or it could be complex where it moves to a different pipeline once you close the first pipeline. Copper presents this as a description of a possible setup, not a mandatory structure for every team. You can use this three-stage example as a simple process you could use, but it does not require that a pipeline must have exactly 3 stages. The documentation describes a choice between a simple flow and a complex one, leaving the final stage count to your specific workflow needs.

In the same documentation, the page explains a visual marker for opportunity value. If you've set your value threshold as $500, any opportunities with a value of $500 or more display a green dollar sign in the lower right corner of the opportunity tile. Copper uses this specific figure to illustrate how the threshold setting works. This $500 figure is an example of a configured value threshold, not a forecast cutoff or a required minimum deal size. The green dollar sign appears based on the threshold you set, not because $500 is a universal standard. Do not treat this marker as a rule that filters deals out of your forecast total; it is a visual indicator tied to your specific configuration.

Win rate and skipped stages change the column

The Opportunity Funnels Report in Close defines how win rates and stage transitions appear in your funnel columns. The report calculates your Win Rate by dividing the number of won Opportunities by the total Opportunities that were won or lost. Because the denominator includes both won and lost deals, the figure reflects actual conversion performance rather than just open pipeline volume.

When an Opportunity moves through the pipeline, it may not visit every stage. The report handles these gaps with a specific rule for Skipped Stages. Opportunities that skip Stages are not included in the counts for those skipped Stages. This means a deal that jumps from one stage to a later one does not inflate the numbers for the intermediate stages it bypassed.

Conversion Rates between Stages follow a similar direct-path logic. These rates only represent Opportunities that converted from the previous Stage directly to the next Stage. If a deal skips a stage, it does not contribute to the conversion rate between the skipped stage and the following one. The metric isolates direct transitions, ensuring that the percentage shown for a specific stage-to-stage move is not diluted by deals that took a different path through the funnel.

These rules mean the numbers in each column depend on the exact path each deal took. A high win rate does not guarantee high conversion rates in every preceding column, especially if many deals skipped intermediate stages. The report separates these metrics so you can see where deals are actually moving compared with where they are being skipped. Before you rely on these figures, see Stage report audit: 4 checks before weekly review.

Your next step before you quote a total

Open your current stage report today and read the header of each column. Label each one as a count, an annualized value, or a weighted value, then quote only the metric that matches your question.

FAQ: Why a funnel total can count the same deal in more than one stage

Can one deal appear in more than one stage column?

Yes, the Opportunity Funnels Report documentation states that summing up each stage won't give you the total number of opportunities. Each opportunity appears in many stages, so it can be counted multiple times in the funnel report. This means the column total is not a unique deal count.

How does Close calculate the win rate?

Close divides the number of won Opportunities by the total Opportunities that were won or lost.

What does a skipped stage do to the count?

If a deal moves from one stage to another without visiting an intermediate stage, that intermediate stage's count does not include the deal. This affects the total number of entries visible in each column.

Is the $500 marker a required cutoff?

No, a $500 value threshold displays a green dollar sign in the lower right corner of the opportunity tile. This is a display setting for opportunities with a value of $500 or more. It does not act as a required forecast cutoff or a mandatory filter for the report.

Sources