Root Cause Analysis (Resolved) Page - Revision history

Hendry.mwamburi: /* Filters */

2026-01-27T12:24:00Z

Filters

@@ Line 10: / Line 10: @@
 !Filter
 !Description
 |-
 |User

Stanley.songok: /* Calculations */

2025-08-15T10:56:29Z

Calculations

← Older revision		Revision as of 12:56, 15 August 2025
Line 74:		Line 74:
	!Description		!Description
	\|-		\|-
	\|1. Number of ticket ~~number~~ by Staff involved		\|1. Number of ticket by Staff involved
	\|Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)]		\|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.		\|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		\|2.Number of ticket by Category name
	\|Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)]		\|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.		\|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		\|3.Number of ticket by Corrective Action
	\|Total Ticket number=COUNT('Performance and Root Cause'[Ticket Number)]		\|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.		\|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.
	\|}		\|}

Hendry.mwamburi at 10:03, 15 August 2025

2025-08-15T10:03:22Z

← Older revision		Revision as of 12:03, 15 August 2025
Line 58:		Line 58:

	* '''Default Behavior:''' The API returns a maximum of '''50 records''' per request unless otherwise specified.		* '''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.
	\|}		\|}

Hendry.mwamburi at 09:56, 15 August 2025

2025-08-15T09:56:55Z

← Older revision		Revision as of 11:56, 15 August 2025
Line 48:		Line 48:
	\|		\|
	*'''API Endpoint:''' <code>[https://customer-service.datacair.com/api/ticket/customfield/5 https://customer-service.datacair.com/api/ticket/customfield/2]</code>		*'''API Endpoint:''' <code>[https://customer-service.datacair.com/api/ticket/customfield/5 https://customer-service.datacair.com/api/ticket/customfield/2]</code>
	* '''Purpose:''' Retrieves ~~Corrective Action~~ custom field values for tickets.		* '''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.		* '''Default Behavior:''' The API returns a maximum of '''50 records''' per request unless otherwise specified.

Hendry.mwamburi at 09:52, 15 August 2025

2025-08-15T09:52:31Z

← Older revision		Revision as of 11:52, 15 August 2025
Line 41:		Line 41:
	\|		\|
	* '''API Endpoint:''' <code>[https://customer-service.datacair.com/api/ticket/customfield/5 https://customer-service.datacair.com/api/ticket/customfield/4]</code>		* '''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 Corrective Action custom field values for tickets.		* '''Purpose:''' Retrieves Corrective Action custom field values for tickets.

Hendry.mwamburi at 09:51, 15 August 2025

2025-08-15T09:51:25Z

← Older revision		Revision as of 11:51, 15 August 2025
Line 35:		Line 35:
	* '''API Endpoint:''' <code>https://customer-service.datacair.com/api/ticket/customfield/5</code>		* '''API Endpoint:''' <code>https://customer-service.datacair.com/api/ticket/customfield/5</code>
	* '''Purpose:''' Retrieves the ''Root cause'' custom field values for tickets.		* '''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.		* '''Default Behavior:''' The API returns a maximum of '''50 records''' per request unless otherwise specified.

Hendry.mwamburi at 09:50, 15 August 2025

2025-08-15T09:50:24Z

@@ Line 24: / Line 24: @@
 !Transformations
 |-
+|
 |}

Stanley.songok: /* Summary */

2025-08-15T08:17:14Z

Summary

← Older revision		Revision as of 10:17, 15 August 2025
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.
	\|}		\|}

David.weller: /* Calculations */

2025-08-14T12:44:38Z

Calculations

← Older revision		Revision as of 14:44, 14 August 2025
Line 22:		Line 22:

	== Calculations ==		== Calculations ==
			[[File:Report-ncrpage-root-cause.png\|none\|thumb\|800x800px]]
	{\| class="wikitable"		{\| class="wikitable"
	\|+		\|+

David.weller: Created page with "== Summary == == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}"

2025-08-14T11:16:46Z

Created page with "== Summary == == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}"

New page

== Summary ==

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|
|
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|
|
|
|}