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.
Staff members involved table API link =https://customer-service.datacair.com/api/ticket/customfield/2	API Endpoint: https://customer-service.datacair.com/api/ticket/customfield/2 Purpose: Retrieves Staff members involved custom field values for tickets. Default Behavior: The API returns a maximum of 50 records per request unless otherwise specified.
Category table API link =https://customer-service.datacair.com/api/ticket/customfield/10	API Endpoint: https://customer-service.datacair.com/api/ticket/customfield/10 Purpose: Retrieves Category involved 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.