Dashpart Bases

Project, Account Detail, Account, Employee, and Favorite Report are the available dashpart bases in Dashpart Designer.

Field Description
Project

This base displays information from the Projects hub, as well as the following metrics:

  • Totals based on transactional information entered for the project.
  • Unbilled labor and expense transaction summary totals, similar to values in an Unbilled Summary Billing report.
  • Draft invoice approval information similar to the information in the Draft Invoice Approval application or on the related report.
  • Accounts receivable information including retainer, retainage, last invoice and last receipt data.

Some columns provide a link that you can click to display additional information. Some display a dialog box with drill-down details on the column, while some display an info bubble with additional information and a link to the relevant hub record. For more information, see Info Bubbles and Help.

When you create a dashpart using this base, the columns available for the dashpart are determined by the activated applications in Vantagepoint. To view WBS levels associated with a project, use the Name and Number columns. When selected, grouping is automatically set up based on the WBS level and these columns display as the first columns on the dashpart.

Cost and billing related columns display values in either the billing or project currency, depending on the configuration of Use Billing (Not Project) Currency for Reporting in Settings > Accounting > Labor Options.

Data Differences Between Project Dashparts Base and Other Applications

There are scenarios where the displayed values in reports and other applications in the system differ from the displayed values in dashboards:

Columns on Cost Amounts
  • The Overhead Allocation Scope and Rate in the Project Earnings report is based on the active company, while the project dashpart base is based on the project company.
  • The Overhead Projects on the Project Earnings report display cost amounts as YTD, while the project dashpart base display cost amounts as JTD.
Columns on Planned Amounts
  • Decimal places can be evaluated per project in the Project Review form, but are evaluated per report in the project dashpart base and project reports.
  • The project dashpart base uses the billing currency for project cost amounts, while the Project Review form uses the cost currency for cost amounts.
Project Detail

This base displays labor and expense transaction detail for projects. This dashpart base is available if you have Accounting or PSA enabled in Vantagepoint. Appropriate access rights are needed to view all the information displayed in this dashpart base. As in the Project dashpart base, data differences are present between the Project Detail dashpart base and other applications. Refer to the Project dashpart base description above for information on these data differences.

Cost and billing related columns display values in either the billing or project currency, depending on the configuration of Use Billing (Not Project) Currency for Reporting in Settings > Accounting > Labor Options.

Account Detail

This base displays information from general ledger account data down to the transaction level.

This dashpart base includes information such as the activity for a certain period (using fiscal and date range filters). You can group information in this base using available columns. You can also total any amount columns and specify filters for fiscal date ranges. For example, you might display activity for particular fiscal periods in each column, so that you can compare activity over time.

This dashpart base is not available if the Vantagepoint database is configured with:

  • Only Resource Planning
  • Only CRM
  • Resource Planning and CRM
Account

This base displays information from general ledger account summary information. This dashpart base is available if Accounting is enabled in Vantagepoint.

Use information from general ledger accounts to create a table or chart dashpart that you can view from a dashboard. You can drill down on the displayed information.

Employee This base displays information from the Employee hub, regular and overtime hours, and Time Analysis information.

You can use this base to analyze employee performance by viewing the way indirect hours are spent by using the time analysis columns, view the percent direct vs indirect for employees. How much time an employee spends on regular and overtime breakdown.

Appropriate access rights are required to view cost-related information. No cost-related information is displayed if you do not have the appropriate access rights, but the column still displays.

Favorite Report

This base displays the selected report from a list of global favorite reports from Reporting.

To modify the information found in a global favorite report, use the Reporting application. Any updates made to global favorite reports are reflected in the Favorite Report dashpart.

If the Always Rebuild Report option is selected when you create or update the Favorite Report table dashpart, then the dashpart refreshes whenever you access the dashboard with the dashpart. Otherwise, the Favorite Report dashpart automatically refreshes the report every 24 hours.

The date and time on which the report was most recently updated displays at the right end of the dashpart title bar. Click in the dashpart title bar to update the Favorite Report table dashpart.

Vantagepoint Intelligence This base displays a selected worksheet from the Vantagepoint Intelligence module.

To display workbooks from Vantagepoint Intelligence in a dashpart:

  • The Vantagepoint Intelligence module must be enabled (Settings > General > Modules).
  • Appropriate access rights are also needed access this base (Settings > Security > Roles).
Web URL Link This base displays a web page in a dashpart.