Jump to content

Root Cause Analysis (Resolved) Page

From PBI Reporting Wiki

Summary

This page forms part of the Non-Conformance Report for Datacair. It consolidates data from SupportPal Non-Conformance Tickets.

The report provides a unified view of non-conformance data across entities and categories. It offers a high-level overview of users and staff involved, enabling quick and easy analysis across all entities.

Filters

Filter Description
User Represents the name of the user involved in the non-conformance.
Staff involved Represents the name of the staffs involved in the non-conformance.

Data Transformation Applied

Query Transformations

Calculations

Columns Calculation Description
1. Number of ticket number by Staff involved Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)] This metric represents the number of times various staff members have been involved in non-conformance incidents, calculated by counting the occurrences of unique ticket numbers associated with staff in the non-conformance records.
2.Number of ticket number by Category name Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)] This metric represents the number of times various categories have been involved in non-conformance incidents, calculated by counting the occurrences of unique ticket numbers associated with category in the non-conformance records.
3.Number of ticket number by Corrective Action Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)] This metric represents the number of times various corrective actions have been taken in non-conformance incidents, calculated by counting the occurrences of unique ticket numbers associated with corrective action in the non-conformance records.