Root Cause Analysis (Resolved) Page

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
Entity table API link =https://customer-service.datacair.com/api/ticket/customfield/6	API Endpoint: `https://customer-service.datacair.com/api/ticket/customfield/6` Purpose: Retrieves the Entity custom field values for tickets. Default Behavior: The API returns a maximum of 50 records per request unless otherwise specified.
Root cause table API link =https://customer-service.datacair.com/api/ticket/customfield/5	API Endpoint: `https://customer-service.datacair.com/api/ticket/customfield/5` Purpose: Retrieves the Root cause custom field values for tickets. Default Behavior: The API returns a maximum of 50 records per request unless otherwise specified.
Corrective Action table API link =https://customer-service.datacair.com/api/ticket/customfield/4	API Endpoint: `https://customer-service.datacair.com/api/ticket/customfield/4` Purpose: Retrieves Corrective Action custom field values for tickets. Default Behavior: The API returns a maximum of 50 records per request unless otherwise specified.

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.