Skip to main content
Planview Customer Success Center

WRK23 - Issue History Analysis

Overview

Issue Log analysis for a portfolio of projects.
Used to analyze the volume and type of issues and rate at which they are being raised and closed.
Chart is drillable to slice/dice the list of issues by an issue attribute or a project name.
Table shows key issue fields, attributes, ownership and date information.

           

Click to expand or shrink

WRK23 example

           

           

Business Outcomes

  • Proactive focus on the highest priority and escalated issues, improving the chances of on time, on cost delivery.
  • Analyze issues by impact and priority and focus attention on them.
  • Capture issue Metrics to improve gating of projects.
  • Governance Board / Steering Committee view into portfolio issues.

           

           

Supporting Capabilities

  • Change, Risk, and Issue Management

           

           

User Parameter Configuration (for Administrators)

Parameters Description Configuration Options Default/Example Settings
Slice By: Issue attribute that will be used to categorize change requests and will be visualized as the stacked bar groups. Any Change/CRI single select attribute, plus project name and activity name. slicer1=cri1_cri
Visualize By: Defines the date field associated with the Issue that will be used to plot on the X-Axis. Any Change/CRI date field, including Initiated (created) date and Close date. visualize_by=initiated_on_cri
Breakdown Chart By: Week, Month, or Quarter time slices in chart or table Controls the table
Options; week, month, quarter 
breakdown_by=month
Start/Finish Date range to be considered Number of breakdown periods backwards that the report looks.

Note: A value of 12 will include 12 whole time slices, plus the current time slice. 

default_horizon=12

           

           

Hidden Parameter Configuration (for Administrators)

Parameters Description Configuration Options Default/Example Settings
Table Columns Total of eight columns available, after the CRI Title.
 
  cri_code
cri_desc1
cri2_cri
cri1_cri
cri3_cri
resp_resource_name_cri
​cri_targetdate
CRI Type Parameter which makes report Issue specific. Since a single RDL (CRI02) is used for all CRI matrix reports, this parameter determines what will be displayed in the report; changes, risks, or issues. cri_type=I
Filter on CRI Attribute

☑ Added in RPM Analytics v2.3.1
This configuration entry identifies the attribute that is to be used in the filter. The configuration entry value is:
  • cri_filter_attrib=attribute ID

 
cri_filter_attrib=

The default/unconfigured value is “none” (no filtering)
CRI Filter Attribute Value

☑ Added in RPM Analytics v2.3.1
This configuration entry identifies the structure_code/sequenceID or user_name of the value to be filtered on (included). The configuration entry value is:
  • cri_filter_value=attribute value ID
To indicate multiple values – make multiple entries
cri_filter_value=

The default/unconfigured value is “none” (no filtering)
Report Title Configurable report title that appears at the top of the report. If a longer report title is required, create additional report_title=xxx entries. These will be concatenated together based on the order in which they are listed in the configuration structure. report_title=Issue History Analysis

           

           

Additional Information

The stacked bar chart segments are drillable. Clicking the number in a cell will filter the lower table to show the issues counted in the stacked bar segment.

           

           

Technical/Database Information

Report (RDL) Location …/Reports/FastTrack/Mixed_Use/CRI02-WorkCRIHistory/CRI02.rdl
Database This report uses the transactional database and updates will be real-time.