Project Staffing

Displays resource allocations on a project, mimicking the Project/Staffing Grouped view. The primary differences between this report and Staffing are that the allocation totals are at the top rather than the bottom and the Total allocations column is to the far right. You can build this report using the design settings in the table below. Alternatively, you can download this report definition and upload it to your PPM Pro instance.

Staffing report.png

 

Design View Selection Comments
General

Topic: Allocated Role

Specialty: Time Series

Type: List: Time Series

Title: <enter a meaningful title>

 

 
Data

List Fields: Add whichever of the following Allocated Role and other fields that would be of value and/or match the Project/Staffing view's columns, such as:

  • Role
  • Resource
  • Memo
  • Bill Rate (may not apply in your instance, if you are not using the billing rate capability)
  • Today's Internal Rate
  • Start Date
  • End Date

Time Series Fields: Only available fields that have a time series indicator appended to their titles - such as '(Time Series)' - should be added to this section (hint: search Available Fields list for 'time series'). From the Allocated Role available fields add the following:

  • Allocation Hours (Time Series), or, Allocation FTE (Time Series)...note that Allocation FTE is not the same as Headcount, so when using FTE there likely will not be a 100% match to the Staffing Headcount results

NOTE: If you are using this report for a single project, for example to be run from a project's report grid or to be included on a project status dashboard, you do not need to include the "Project" field. However, if you will be running this report across a portfolio of projects, you will likely want to include the "Project" field first/before "Role".

To change the field Display Names, within the List Fields area select the edit icon for "Show Field Options" and in the resulting "Field Options" modal, edit the Display Name. You can also change the Display Data As format options for various fields in this modal.

Screen Shot 2022-02-16 at 2.36.23 PM.png

Screen Shot 2022-02-16 at 2.36.50 PM.png
Display

Configure desired options within the Display tab, such as:

  • Headings - Time Series Width Percent
  • Data - Show zero values 'Show as blank'
  • Sorting
    • Priority 1 field "Role" with Group By "Group and total"
    • Priority 2 field "Resource"
  • Aggregation
    • Field "Allocation Hours" or "Allocation FTE" Aggregation "Sum"
    • Grand aggregation position "Show at top"
    • Sub-total position "Show at bottom with group label at top"

 

If you prefer the Project/Staffing List view, do not use "Group and total" for the "Role" field in Sorting.

If you will be running this report across a portfolio of projects, you will likely want to make the Sorting Priority 1 field "Project" with Group By "Group".
Variable Settings

Scope: Project, so that the report will appear in the Project/Reports grids

Filters: Any allocated role filters

Time Series: Select a Frequency and Date Range appropriate to your report needs, such as:

  • Frequency that matches the Project/Staffing "Interval" selection, such as "Monthly"
  • Date Range that is meaningful, such as 'is next NNN months, including this month' for 12 months

 

If you would like to allow changing Filters or the Time Series selections before running the report or when viewing the report, select the 'Allow changing' checkbox options for each.