Root Cause Analysis (Resolved) Page: Difference between revisions
Appearance
David.weller (talk | contribs) |
|||
| 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. |