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:

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.