Actual or Target Revenue vs. Baseline or Forecast Chart

This bar chart displays the actual or target revenue trends for prior and current periods, and budget or forecast revenue amounts for future periods. You can select the how you want to view revenue, either over a specific time period or year-to-date (YTD). These options give you the ability to accurately assess the different aspects of revenue for your entire firm, or for individual organizations.

 

In this topic

Chart Format

Chart Data

Prior Year Revenue Adjustments

Period or YTD

User Options That Affect the Chart

Maximize the Chart

Focus the Chart

Display Data Point Information

Send the Chart Data to Excel

Other Chart Actions

Chart Format

Chart Item

Description

Horizontal axis: timeframe

The horizontal axis displays the fiscal periods included in the analysis period.

Vertical axis: current value

The vertical axis displays the scale for revenue amounts.

Chart Data

The following data displays on this chart:

Chart Item

Description

Bars

The chart displays the revenue trends for the analysis period.

The actual revenue amounts display as filled bars.

The projected revenue amounts for future months display as clear bars.

If the data model includes a prior year revenue adjustment amount for a fiscal period, the adjustment amount displays as a separate segment in the bar for that fiscal period. See Prior Year Revenue Adjustments below for more information.

For descriptions of the sources of the data used in revenue, see Data Sources.

Symbols: Baseline Budget or Forecast

The baseline budget or forecast trends for the analysis period display as a black square on each bar on the chart.

For descriptions of the sources of the data used in revenue, see Data Sources.

Prior Year Revenue Adjustments

If the data model includes a prior year revenue adjustment amount for a fiscal period, the adjustment amount displays as a separate segment in the bar for that fiscal period:

Position the mouse pointer over the bar to display the exact revenue adjustment amount and net revenue amount in a data box.

Note: If Costpoint Analytics is configured to include prior year adjustments, this is the only chart that breaks out prior year revenue adjustments separately. For all other charts and tables that display revenue, with one exception, the revenue amounts are the net revenue after adjustments. The exception is the Ad Hoc Data Discovery table. To display prior year revenue adjustment amounts in that table, select the Revenue Adjustment metric.

Period or Year-to-Date

There are two ways to view revenue: Period and Year-To-Date (YTD). The type of chart impacts the data that displays on the charts.

Period is data for the current analysis period, while YTD provides a cumulative, rolling perspective within a given year. For example, February = January + February, March =  January + February + March, and so on.

Profit defaults to YTD when used initially, but you can switch the chart type at any time.  

To switch the type of chart...

  1. Locate the chart type options.  

  2. Click Period or YTD. The selected option's button turns green, and the pertinent information on the charts and tables updates to reflect your selection.

User Options That Affect the Chart

The following options on the User Options tab affect this chart:

For descriptions of how each option affects Revenue Analytics, see User Options That Affect Revenue.

Maximize the Chart

Click at the top right of the chart to display the chart at its maximum size. Click to restore the chart to its original size and location on the tab.

Focus the Chart

To focus the chart on a particular set of data points, click and drag the mouse pointer over the chart so that all of those data points are included in the green selection area.

Illustration

To focus the chart on a more restricted analysis period, do either of the following:

It is much easier to make selections on the chart itself if you first maximize the chart.

Display Data Point Information

To see the revenue amount and budget baseline or forecast as of a specific fiscal period, position the mouse pointer over bar for that period. When you do, Costpoint Analytics displays the amounts in a data box.

It is much easier to position the mouse pointer over a data point if you first maximize the chart.

Illustration

Send the Chart Data to Excel

Click to send the data underlying the chart to Microsoft Excel. More...

Other Chart 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.