Root Cause Analysis (Resolved) Page: Difference between revisions
David.weller (talk | contribs) Created page with "== Summary == == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}" |
|||
| (7 intermediate revisions by 3 users not shown) | |||
| 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 18: | 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. | |||
|- | |||
|Corrective Action table API link =[https://customer-service.datacair.com/api/ticket/customfield/6?limit=1000000000 https://customer-service.datacair.com/api/ticket/customfield/4] | |||
| | | | ||
* '''API Endpoint:''' <code>[https://customer-service.datacair.com/api/ticket/customfield/5 https://customer-service.datacair.com/api/ticket/customfield/4]</code> | |||
* '''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/6?limit=1000000000 https://customer-service.datacair.com/api/ticket/customfield/2] | |||
| | |||
*'''API Endpoint:''' <code>[https://customer-service.datacair.com/api/ticket/customfield/5 https://customer-service.datacair.com/api/ticket/customfield/2]</code> | |||
* '''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/6?limit=1000000000 https://customer-service.datacair.com/api/ticket/customfield/10] | |||
| | |||
*'''API Endpoint:''' <code>[https://customer-service.datacair.com/api/ticket/customfield/5 https://customer-service.datacair.com/api/ticket/customfield/10]</code> | |||
* '''Purpose:''' Retrieves Category involved custom field values for tickets. | |||
* '''Default Behavior:''' The API returns a maximum of '''50 records''' per request unless otherwise specified. | |||
|- | |||
|Datacair tickects table API link =<nowiki>https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000</nowiki> | |||
| | |||
* '''API Endpoint''': <code><nowiki>https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000</nowiki></code> | |||
* '''Purpose''': Retrieves comprehensive ticket information for department ID '''4''', including metadata and key lifecycle fields. The <code>limit</code> parameter is explicitly set to a very high value to ensure all relevant records are returned in a single call, bypassing default pagination limits. | |||
|} | |} | ||
== Calculations == | == Calculations == | ||
[[File:Report-ncrpage-root-cause.png|none|thumb|800x800px]] | |||
{| class="wikitable" | {| class="wikitable" | ||
|+ | |+ | ||
| Line 28: | Line 74: | ||
!Description | !Description | ||
|- | |- | ||
| | |1. Number of ticket 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 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 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. | |||
|- | |||
|4. Number of ticket By Action Taken | |||
|Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)] | |||
|This metric represents the number of times various actions have been taken in non-conformance incidents, calculated by counting the occurrences of unique ticket numbers associated with action taken in the non-conformance records. | |||
|- | |||
|5.Ticket and Staff Involvement Table Summary | |||
|Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)] | |||
|The table provides a concise overview of key metrics related to ticket numbers and staff involvement in non-conformance incidents, alongside transaction and staffing metrics, for easy monitoring and analysis. | |||
|} | |} | ||
Latest revision as of 11:56, 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 |
|
| Corrective Action table API link =https://customer-service.datacair.com/api/ticket/customfield/4 |
|
| Staff members involved table API link =https://customer-service.datacair.com/api/ticket/customfield/2 |
|
| Category table API link =https://customer-service.datacair.com/api/ticket/customfield/10 |
|
| Datacair tickects table API link =https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000 |
|
Calculations
| Columns | Calculation | Description |
|---|---|---|
| 1. Number of ticket 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 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 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. |
| 4. Number of ticket By Action Taken | Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)] | This metric represents the number of times various actions have been taken in non-conformance incidents, calculated by counting the occurrences of unique ticket numbers associated with action taken in the non-conformance records. |
| 5.Ticket and Staff Involvement Table Summary | Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)] | The table provides a concise overview of key metrics related to ticket numbers and staff involvement in non-conformance incidents, alongside transaction and staffing metrics, for easy monitoring and analysis. |