Skip to main content

 

Planview Customer Success Center

Request Average Days at Gates

Per request, see the total number of days it spent at each workflow gate and the overall average days at gates and overall average days for all requests per gate:

Request Average Days at Gates.png

Design View Selection Comments
General

Topic: Request

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 Request > Gate Time Summaries > Gate.

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

Values: Whichever fields (up to 10) would be of value for representing time spent at a gate, such as Request > Gate Time Summaries > Elapsed Gate 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-17 at 5.19.03 PM.png

Screen Shot 2021-08-17 at 5.19.16 PM.png

When starting with the Request topic you will need to select the field path Request > Gate Time Summaries to get to the time at gate-specific available fields. For example:

Screen Shot 2021-08-17 at 5.17.54 PM.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 Request Title and second as Gate (Direction: List order)
  • Set Aggregation of the Elapsed Gate Time (Days) to Average
 
Variable Settings

Scope: Organization

Filters: optionally include request filters, such as requests with Gate Status of In Progress specific and a specific request Category if you have multiple of these with different gate workflows

 

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