Closed Issue Dashboard

The Closed Issue dashboard displays the details of the issues that are closed. The dashboard helps project managers view the issue patterns and improve future performance.

The dashboard uses the Project Management - Project Issues Real Time subject area.

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

  • Issue Details Report

  • Action Item Details Report

Key Insights

This dashboard answers the following business questions:

  • How were issues resolved?

  • What was the actual timeliness for closing issues?

  • How were action items related to the issue resolved?

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 details of the issues closed for your project or for the issues you own.

What can I do with this dashboard?

You can:

  • View the closed issues by:

    • Issue Type

    • Closed Reason

  • Drill down to the:

    • Issue Details analysis using the Count of Issues column.

    • Action Item Details analysis using the Action Items column.

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

Issue Status

Filter

is equal to / is in Closed

Issue Creation Date

Dashboard prompt

  • Calendar

  • Default selection SQL:

    SELECT CAST(TIMESTAMPADD(SQL_TSI_MONTH,-{3}, CURRENT_DATE) As Date) from "Project Management - Project Issues Real Time"

Issue Creator

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Issue Type

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Project Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

The following table lists the views in the Closed Issue Analysis.

View

Displayed Information

View Name

Closed Issue Analysis

View Sections

None

Table Column and Measures

  1. Issue Type

  2. Closed Reason

  3. Issue Resolution

  4. Issue Summary

  5. Issue Duration

  6. Actual Timeliness

  7. Action Items

  8. Owner

  9. Issue Description