1. Projects
  2. Project Management
  3. Project Management Reports
  4. Actual Time Workbook
  5. Actual Time Dataset

Actual Time Dataset

This dataset combines fields from the Time Tracking record type and seven custom formulas enabling you to closer monitor how time is being utilized across your projects. It forms the source data for the Actual Time Workbook.

Prerequisites

The following features should be enabled for the workbook to appear in the list of standard workbooks.

  1. Time Tracking

  2. Project Management

Dataset Configuration

The Actual Time dataset combines fields from one record type, multiple custom formulas, and criteria filters. To edit the dataset, see Defining a Dataset.

Root Record Type

Joined Record Type

Custom Formula Fields

Data Grid

Criteria Filters

Time Tracking

(none)

The following custom formula fields are included in the dataset:

  • Billable Time

  • Exempt Time

  • Non-billable Time

  • Non-Productive Time

  • Productive Time

  • Time Usage

  • Utilized Time

The following fields are included in the dataset.

Time Tracking:

  • Class

  • Customer:Project

  • Date

  • Department

  • Duration

  • Employee

  • Service Item

The following criteria is used to filter the dataset:

  • Date on or after same day last year

  • Type is Actual Time

Related Reports

Related Topics

General Notices