Top Projects

The Top Projects table displays an overview of the top project's details. This is a blended view that is broken down by various attributes that you select. Typically, the top projects are those that are the most profitable performers.  

The Top Projects table displays an overview of the details for the projects that are the top performers within a set of established criteria. For example, if you want to review a forecast of the year's top ten projects by revenue, you can specify the filter criteria to display these projects over the desired time period.

The start and end date for the analysis period displays as part of the caption, and updates as you change dates.

The default view for this chart is your entry level organization. You can click and drag any number of organizations from the Organization Hierarchy section to include multiple organizations in the comparison. You can also select from other attributes, including the Project Type, Project Manager, and Customer. The chart continues to update as you add and remove attributes to compare.

In this topic

Display the Table

Chart Data

Period or YTD

User Options That Affect This Chart

Change the Analyzed Attribute

Change the Top-Level Project Name View

Maximize the Chart

Focus the Chart

Send the Chart Data to Excel

Other Chart Actions

 

Display the Table

By default, the top projects table is minimized at the bottom of the analytic:

To display it, double-click Top Projects, or right-click Top Projects and select either Restore or Maximize on the pop-up menu.

Chart Data

The following data displays on this table:  [REWRITE IF KEEPING]

Table Item

Description

Organization View

By default, the table displays the revenue information by top-level organization, but you have the option to display the distribution by any of the following:

  • Any organization level

  • Project type

  • Project manager

  • Customer

See Change the Analyzed Attribute for more information.

Projects

By default, the table displays the revenue information by top-level project, but you have the option to filter the Project column by any of the following:

  • Revenue Project Name

  • Top-level Project ID - Name

  • Revenue Project ID - Name

See Change the Top-level Project Name View for more information.

Blended Actual Amount or Blended Gross Profit Amount

The information that displays (profit or gross profit) depends on the Profit Type setting in User Options.

If a time frame beyond the current period is selected, projections in this column also include the baseline or forecast data. This depends on the Budget Type setting in User Options.  

This column sorts in descending order by Organization Level, Project Type, Project Manager, and Customer if the Chart Type is set to Amount.

Blended Profit Margin

The information that displays (profit or gross margin) depends on the Profit Type setting in User Options.

If a time frame beyond the current period is selected, projections in this column also include the baseline or forecast data. This depends on the Budget Type setting in User Options.  

This column sorts in descending order by Organization Level, Project Type, Project Manager, and Customer if the Chart Type is set to Amount.

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 Profit Analytics, see User Options That Affect Revenue.

Change the Analyzed Attribute

By default, the Top Projects table displays the revenue information by top-level organization, but you have the option to display the distribution by any of the following:

To change the view, do either of the following:

Or

If you apply dashboard filters before you change the view, the table only displays items that satisfy those filters. For example, if you select two project managers in the Project Manager list under Other Attributes, and then use to display by Project Type, the table only displays the variance for the two project manager by project type.

Change the Top Level Project Name View

By default, the Top Projects table displays the revenue information by top-level project, but you have the option to filter the Project column by any of the following:

To change the view, do either of the following:

Or

Maximize the Table

Click to display the table at its maximum size so you can read it and interact with it more easily. Click to restore the table 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 so that all of those data points are included in the green selection area. Illustration

To focus the chart on one period of revenue information, do either of the following:

 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.

If you use any of the above actions to change the chart, Costpoint Analytics applies the same changes, as appropriate, to all other analytic objects.

Display Data Point Information

To see the revenue amount as of a specific fiscal period, position the mouse pointer over the symbol of the revenue's trend line with the vertical grid line for the timeframe. When you do, Costpoint Analytics displays the revenue amounts in a small box for the Month/Year and Baseline. Illustration

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

Send the Table Data to Excel

Click 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.