Root Cause Analysis (Resolved) Page: Difference between revisions
No edit summary |
|||
| Line 24: | Line 24: | ||
!Transformations | !Transformations | ||
|- | |- | ||
|Entity table API link =[https://customer-service.datacair.com/api/ticket/customfield/6?limit=1000000000 https://customer-service.datacair.com/api/ticket/customfield/6] | |||
| | | | ||
* '''API Endpoint:''' <code>[https://customer-service.datacair.com/api/ticket/customfield/5 https://customer-service.datacair.com/api/ticket/customfield/6]</code> | |||
* '''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/6?limit=1000000000 https://customer-service.datacair.com/api/ticket/customfield/5] | |||
| | |||
* '''API Endpoint:''' <code>https://customer-service.datacair.com/api/ticket/customfield/5</code> | |||
* '''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. | |||
|} | |} | ||
Revision as of 10:50, 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 |
|---|---|
| Entity table API link =https://customer-service.datacair.com/api/ticket/customfield/6 |
|
| Root cause table API link =https://customer-service.datacair.com/api/ticket/customfield/5 |
|
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. |