Skip to main content
Planview Customer Success Center

Resource Average Days per Request Action

Per resource, see the total number of days requests spend before the person took a specific action, the overall average days for all actions for a resource, and overall average days for all resources per action. 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.

Resource Average Days per Request Action.png

Design View Selection Comments
General

Topic: Resource

Type: Crosstab

Title: <enter a meaningful title>

 

 

Data

Top Axis: Whichever fields (up to 10) would be of value for breaking up the data, such as Resource > Gate Actions: Gate Approver > Action.

Left Axis: Whichever fields (up to 10) would be of value for organizing requests, such as by Name: Last, First.

Values: Whichever fields (up to 10) would be of value for representing time spent at a gate, such as Resource > Gate Actions: Gate Approver > Elapsed Gate Approver Time (Days).

To change the field title/heading value Display Name and Display Data as options, you can use the Field Options modal.

Screen Shot 2021-08-18 at 10.05.16 AM.png

Screen Shot 2021-08-18 at 10.04.28 AM.png

When starting with the Resource topic you will need to select the field path Resource > Gate Actions: Gate Approver to get to the time and approver-specific available fields. For example:

Screen Shot 2021-08-18 at 10.07.07 AM.png

Display

Select desired options within the Display tab, such as Sorting, Drilldown, or Aggregation (including row and column subtotals and grand totals):

  • Add first Sort Priority as the Resource Name: Last, First
  • Set Aggregation of the Elapsed Gate Approver Time (Days) to Average
 
Variable Settings

Scope: Organization

Filters: optionally include resource filters

 

Selecting the Organization Scope will cause this report to be available on the Organization Report grid so it can be run per the organization.