Jump to content

Root Cause Analysis (Resolved) Page: Difference between revisions

From PBI Reporting Wiki
Line 1: Line 1:
== Summary ==
== 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 ==
== Filters ==
Line 8: Line 11:
!Description
!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.
|}
|}


Line 29: Line 35:
!Description
!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.
|}
|}

Revision as of 09:17, 15 August 2025

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.