Pipeline Chart

The Pipeline chart in the Dashboard area provides a summary view of revenue for the opportunities in your pipeline. For each dimension value on the vertical axis, the chart displays estimated and weighted revenue amounts in separate bars.

You can use searches to select the opportunities that are included, and you can specify the vertical axis dimension and the time frame.

Pipeline Calculation

To determine each opportunity's contribution to pipeline revenue, Deltek CRM spreads the revenue amount for each opportunity evenly across the period from that opportunity's start date to its end date to determine per-day revenue. It then uses the opportunity start and end dates to determine the number of days each opportunity will contribute revenue during the Pipeline chart time frame, and multiplies that number of days by the per-day revenue amounts to determine that opportunity's contribution to the revenue shown in the chart.

Example: The number of days between the start and end dates for Opportunity 100 is 300 days, and the estimated revenue for the opportunity is 3,000,000. Based on that information, Deltek CRM calculates a per-day revenue amount of 10,000 (3,000,000 total revenue / 300 days). You select Next 6 Months as the time frame for the Pipeline chart. Deltek CRM uses the start and end dates for Opportunity 100 to determine that the opportunity would contribute revenue for 120 of the days in that six month time frame. As a result, Opportunity 100's pipeline revenue contribution for that time frame is 1,200,000 (120 days x 10,000 revenue per day).

An opportunity's contribution to weighted revenue for the Pipeline chart is calculated in exactly the same way, once the weighted revenue is calculated (Estimated revenue x Probability).

Note that because a start and end date and an estimated revenue amount are required for the calculation of pipeline revenue amounts, the chart excludes opportunities that do not have all three of those values.

Contents

Field Description
Search list

On the drop-down list to the right of the chart name, click All to display all opportunities (both active and inactive) on the chart, click Active to include only opportunities with the Active status, or click Mine to display only opportunities with which you are associated as a team member.

To apply a custom search rather than one of the standard ones described above, click one of the saved custom searches listed below the standard ones, or click Custom to create a new custom search. In the Custom Opportunity Search dialog box, you can select search values for selected fields in the records.

To see the search criteria for the currently selected custom search in a tooltip, hover over the search name if the search is saved, or over Custom if it is not saved.

Dimension selection

Click the currently selected dimension, located above the upper-left corner of the chart, to change the dimension by which pipeline revenue is broken down on the vertical axis (for example, by primary client, project manager, market, or stage).

The dimension selections include all standard and custom fields for opportunities that have a lookup list or drop-down list of values. In addition, a By Month option enables you to display a month-by-month breakdown of revenue for the time frame you select for the chart.

Time frame selection

Click the currently selected time frame, located above the upper-left corner of the chart, to change the overall period of time represented on the chart.

The revenue bars on the chart represent the total estimated or weighted revenue for the selected time frame. For example, if you select Next 6 Months (Projected), each bar represents the estimated or weighted revenue for that group of opportunities for the next six months, starting on the current date.

Vertical axis values The vertical axis of the chart displays the values for the dimension that you select above the chart. Estimated revenue and weighted revenue bars display for each dimension value. If no pipeline revenue exists for a dimension value, that value does not display on the axis.
Horizontal axis values The horizontal axis of the chart displays the scale of revenue amounts.
Weighted revenue bars

Each weighted revenue bar represents the sum of weighted revenue for that group of opportunities for the time frame. Hover over the bar to display the weighted revenue amount and the number of opportunities contributing to that amount.

Weighted revenue for an opportunity = Estimated revenue x Probability.

Deltek CRM spreads the weighted revenue amount for each opportunity evenly across the period from that opportunity's start date to its end date to determine per-day weighted revenue. It then uses the opportunity start and end dates to determine the number of days each opportunity will contribute revenue during the Pipeline chart time frame, and multiplies that number of days by the per-day weighted revenue amounts to determine that opportunity's contribution to the weighted revenue shown in the chart.

Estimated revenue bars

Each estimated revenue bar represents the sum of estimated revenue for that group of opportunities for the time frame. Hover over the bar to display the estimated revenue amount and the number of opportunities contributing to that amount.

Deltek CRM spreads the estimated revenue amount for each opportunity evenly across the period from that opportunity's start date to its end date to determine per-day estimated revenue. It then uses the opportunity start and end dates to determine the number of days each opportunity will contribute revenue during the Pipeline chart time frame, and multiplies that number of days by the per-day estimated revenue amounts to determine that opportunity's contribution to the estimated revenue shown in the chart.