Historical Pipeline Change Detail Table

The Historical Pipeline Change Detail table displays, for each opportunity included in the historical pipeline data, all changes in stage, probability, and pipeline amount that occurred during the analysis period. The date of the change and the user who made the change are also included.

 

In this topic

Display the Table

Table Data

Pipeline Amounts

Maximize the Table

Focus the Table

Sort the Table

Send the Table Data to Excel

Other Table Actions

Display the Table

If the Historical Pipeline Change Detail table is not visible, click the Change Detail tab.

HP_Change_Detail_Tab.png

Table Data

Data Item

Description

Stage, probability, and pipeline "before" amount

The opportunity's stage, probability, and pipeline amount on the indicated date before any changes occurred.

Stage, probability, and pipeline "after" amount

The opportunity's stage, probability, and pipeline amount on the indicated date after the last change occurred.

For descriptions of the sources of the table data, see Data Sources.

Important Note on Historical Pipeline Data Detail

The before and after values for each opportunity and date are the beginning values and ending values for that date. If the value of a tracked item changed more than once on a given date, the table does not show those interim values.

Pipeline Amounts

When your firm implements Capture Analytics, it can select two amount fields from opportunity records in GovWin Capture Management to analyze as pipeline. When Capture Analytics stores historical pipeline information, it includes pipeline amounts for each opportunity based on the amounts in each of those fields. As a result, you can use the options under Pipeline Amount to display historical pipeline using amounts from either of those two fields.

The Unweighted and Weighted options under Pipeline Probability Weighting provide the additional option to display either unweighted or weighted historical pipeline amounts. Weighted pipeline amounts are pipeline amounts with the probabilities applied. Capture Analytics calculates the weighted pipeline amount for each opportunity for a given week or month as follows: Historical pipeline amount × (Historical probability ÷ 100).

Maximize the Table

Click maximizechart.png to display the table at its maximum size so you can read it and interact with it more easily. Click RestoreChart.png to restore the table to its original size and location on the tab.

Focus the Table

You can narrow the focus of this table in any of the following ways:

If you focus the table in one of these ways, Capture Analytics applies the same change, as appropriate, to all other analytic objects.

Sort the Table

To sort the table based on the values in one of the columns, double-click the column heading for that column.

To change the sort order from ascending to descending or from descending to ascending, double-click the column heading of the current sort column.

Send the Table Data to Excel

Click SendToExcel.png to send the data underlying the table to Microsoft Excel. More...

Other Table Actions

In addition to the actions described above, you can also do the following:

For more on these actions, see Print, Email, or Export Analytic Data and Attach Notes to Analytics.