1. Creating and Administering Analytics and Reports for Project Management
  2. Issue Aging Dashboard

Issue Aging Dashboard

The Issue Aging dashboard displays the number of issues grouped by the days they are open, for example, less than a month, more than a month, and so on.

You can also view the number of issues for each issue status. The dashboard uses the Project Management - Project Issues Real Time subject area.

The dashboard consists of Issue Aging Report and you can drill down to the following analyses from the Issue Aging Report.

  • Issue Details Report

  • Action Item Details Report

Key Insights

This dashboard answers the following business question:

  • What are the total number of issues by age and status?

Frequently Asked Questions

The following table lists the frequently asked questions about this dashboard.

FAQ

Answer

How do I find this dashboard?

Reports and Analytics - Shared Folders - Projects - Project Execution Sample Reports

Who uses this dashboard?

Project Manager

When do I use this dashboard?

When you need to know the number of open issues by their age and status.

What can I do with this dashboard?

You can view the number of issues by age range and take appropriate actions on them.

What type of dashboard is this?

Oracle Transactional Business Intelligence

Details

The following table lists the prompts and filters used in the dashboard.

Column

Type

Rules

Project

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Owner

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

  • Default selection SQL:

    SELECT "Issue Owner"."Issue Owner" FROM "Project Management - Project Issues Real Time" where "Issue Owner"."Issue Owner" =VALUEOF(NQ_SESSION.USER)

Issue Status

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: SQL Results

    SELECT "Issue Status"."Issue Status" FROM "Project Management - Project Issues Real Time" where "Issue Status"."Issue Status" <> 'Closed' FETCH FIRST 65001 ROWS ONLY

  • Default selection SQL:

    SELECT "Issue Status"."Issue Status" FROM "Project Management - Project Issues Real Time" where "Issue Status"."Issue Status" IN ('New','In progress')

The following table lists the views in the Issue Aging Report.

View

Displayed Information

View Name

Issue Aging Report

View Sections

None

Table Column and Measures

  1. Number Of Issues

  2. Age

  3. Issue Status