NCR Report Analysis - Revision history

Stanley.songok: /* Summary */

2025-08-15T11:48:04Z

Summary

← Older revision		Revision as of 13:48, 15 August 2025
Line 1:		Line 1:
	== Summary ==		== Summary ==

			This page forms part of the Non-Conformance Report for Datacair. It consolidates data from both the NCR Database.

			The report provides a unified view of non-conformance data across entities, staffs and ,users It offers a high-level overview of staff attendance and work rates, enabling quick and easy analysis across all entities.

	== Filters ==		== Filters ==

Stanley.songok: /* Filters */

2025-08-15T11:44:22Z

Filters

← Older revision		Revision as of 13:44, 15 August 2025
Line 8:		Line 8:
	!Description		!Description
	\|-		\|-
	\|		\|Date
	\|		\|Filters data based on dates when staff activities were recorded, as well as entities (business units) and regions, allowing users to view staff metrics for specific time periods, entities, and geographic regions.
			\|-
			\|Entity & Region
			\|Filters data based on entities (business units) and regions where NCRs were recorded, allowing users to view staff involvement in non-conformance incidents specific to selected entities and geographic regions.
			\|-
			\|Staff
			\|Filters data based on entities (business units) and regions where staff activities were recorded, allowing users to view staff metrics specific to selected entities and geographic regions.
	\|}		\|}

Stanley.songok at 11:32, 15 August 2025

2025-08-15T11:32:47Z

← Older revision		Revision as of 13:32, 15 August 2025
Line 42:		Line 42:
	\|Total NCR's =		\|Total NCR's =
	COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[id]), 0)		COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[id]), 0)
	\|The Total NCRs metric shows the number of unique Non-Conformance Reports (NCRs) by counting distinct ticket IDs from the 'NCR_page_datacaire_tickets' dataset. If no unique IDs are found, it defaults to 0.		\|
	The table displays Total NCRs alongside dates, entities, and regions. Each row shows the count of unique NCRs for a specific date, entity, and region, making it easy to track non-conformance trends across different time periods and locations.		*The Total NCRs metric shows the number of unique Non-Conformance Reports (NCRs) by counting distinct ticket IDs from the 'NCR_page_datacaire_tickets' dataset. If no unique IDs are found, it defaults to 0.
			*The table displays Total NCRs alongside dates, entities, and regions. Each row shows the count of unique NCRs for a specific date, entity, and region, making it easy to track non-conformance trends across different time periods and locations.
	\|-		\|-
	\|2. Number of Tickets By Creation Dates		\|2. Number of Tickets By Creation Dates
	\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)		\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)
	\|The Total Tickets metric counts all ticket IDs in the 'NCR_page_datacaire_tickets' dataset, representing the total number of tickets created.		\|
	Displayed in a donut chart, where each segment shows the proportion of tickets created by individual users, allowing easy comparison of ticket creation activity by user.		*The Total Tickets metric counts all ticket IDs in the 'NCR_page_datacaire_tickets' dataset, representing the total number of tickets created.
			*Displayed in a donut chart, where each segment shows the proportion of tickets created by individual users, allowing easy comparison of ticket creation activity by user.
	\|-		\|-
	\|3.Staff and Ticket Metrics Table		\|3.Staff and Ticket Metrics Table
	\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)		\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)
	\|*The Staff and Ticket Metrics Table offers a concise overview of ticket and staff-related data. It displays the total number of tickets from the 'NCR_page_datacaire_tickets' dataset, alongside staff metrics from the 'NCR Database Combined' dataset, including Staffed Rostered (scheduled staff), Staff Attended (staff who worked), and Staff on Leave, each defaulting to 0 if no data exists. The table also includes entities (business units) and regions, enabling users to efficiently track ticket volumes and staff activity across different locations and departments.		\|
			*The Staff and Ticket Metrics Table offers a concise overview of ticket and staff-related data. It displays the total number of tickets from the 'NCR_page_datacaire_tickets' dataset, alongside staff metrics from the 'NCR Database Combined' dataset, including Staffed Rostered (scheduled staff), Staff Attended (staff who worked), and Staff on Leave, each defaulting to 0 if no data exists.
			* The table also includes entities (business units) and regions, enabling users to efficiently track ticket volumes and staff activity across different locations and departments.
	\|-		\|-
	\|4. Total NCR Reports by Entity and Region		\|4. Total NCR Reports by Entity and Region
	\|Total NCR's =		\|Total NCR's =
	COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[id]), 0)		COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[id]), 0)
	\|*The Total NCRs metric counts unique Non-Conformance Reports (NCRs) by tallying distinct ticket IDs from the 'NCR_page_datacaire_tickets' dataset, defaulting to 0 if no unique IDs exist.		\|
			*The Total NCRs metric counts unique Non-Conformance Reports (NCRs) by tallying distinct ticket IDs from the 'NCR_page_datacaire_tickets' dataset, defaulting to 0 if no unique IDs exist.
	*Displayed as an area chart, where the x-axis represents time (e.g., dates), and the y-axis shows the count of unique NCRs. The chart is segmented by entities (business units) and regions, with each area representing the NCR count for a specific entity-region combination, allowing users to visualize trends and compare non-conformance activity across different entities and regions over time.		*Displayed as an area chart, where the x-axis represents time (e.g., dates), and the y-axis shows the count of unique NCRs. The chart is segmented by entities (business units) and regions, with each area representing the NCR count for a specific entity-region combination, allowing users to visualize trends and compare non-conformance activity across different entities and regions over time.
	\|}		\|}

Stanley.songok at 11:30, 15 August 2025

2025-08-15T11:30:21Z

← Older revision		Revision as of 13:30, 15 August 2025
Line 52:		Line 52:
	\|3.Staff and Ticket Metrics Table		\|3.Staff and Ticket Metrics Table
	\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)		\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)
	\|The Staff and Ticket Metrics Table offers a concise overview of ticket and staff-related data. It displays the total number of tickets from the 'NCR_page_datacaire_tickets' dataset, alongside staff metrics from the 'NCR Database Combined' dataset, including Staffed Rostered (scheduled staff), Staff Attended (staff who worked), and Staff on Leave, each defaulting to 0 if no data exists. The table also includes entities (business units) and regions, enabling users to efficiently track ticket volumes and staff activity across different locations and departments.		\|*The Staff and Ticket Metrics Table offers a concise overview of ticket and staff-related data. It displays the total number of tickets from the 'NCR_page_datacaire_tickets' dataset, alongside staff metrics from the 'NCR Database Combined' dataset, including Staffed Rostered (scheduled staff), Staff Attended (staff who worked), and Staff on Leave, each defaulting to 0 if no data exists. The table also includes entities (business units) and regions, enabling users to efficiently track ticket volumes and staff activity across different locations and departments.
	\|-		\|-
	\|4. Total NCR Reports by Entity and Region		\|4. Total NCR Reports by Entity and Region
	\|Total NCR's =		\|Total NCR's =
	COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[id]), 0)		COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[id]), 0)
	\|The Total NCRs metric counts unique Non-Conformance Reports (NCRs) by tallying distinct ticket IDs from the 'NCR_page_datacaire_tickets' dataset, defaulting to 0 if no unique IDs exist.		\|*The Total NCRs metric counts unique Non-Conformance Reports (NCRs) by tallying distinct ticket IDs from the 'NCR_page_datacaire_tickets' dataset, defaulting to 0 if no unique IDs exist.
	Displayed as an area chart, where the x-axis represents time (e.g., dates), and the y-axis shows the count of unique NCRs. The chart is segmented by entities (business units) and regions, with each area representing the NCR count for a specific entity-region combination, allowing users to visualize trends and compare non-conformance activity across different entities and regions over time.		*Displayed as an area chart, where the x-axis represents time (e.g., dates), and the y-axis shows the count of unique NCRs. The chart is segmented by entities (business units) and regions, with each area representing the NCR count for a specific entity-region combination, allowing users to visualize trends and compare non-conformance activity across different entities and regions over time.
	\|}		\|}

Stanley.songok at 11:28, 15 August 2025

2025-08-15T11:28:36Z

← Older revision		Revision as of 13:28, 15 August 2025
Line 53:		Line 53:
	\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)		\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)
	\|The Staff and Ticket Metrics Table offers a concise overview of ticket and staff-related data. It displays the total number of tickets from the 'NCR_page_datacaire_tickets' dataset, alongside staff metrics from the 'NCR Database Combined' dataset, including Staffed Rostered (scheduled staff), Staff Attended (staff who worked), and Staff on Leave, each defaulting to 0 if no data exists. The table also includes entities (business units) and regions, enabling users to efficiently track ticket volumes and staff activity across different locations and departments.		\|The Staff and Ticket Metrics Table offers a concise overview of ticket and staff-related data. It displays the total number of tickets from the 'NCR_page_datacaire_tickets' dataset, alongside staff metrics from the 'NCR Database Combined' dataset, including Staffed Rostered (scheduled staff), Staff Attended (staff who worked), and Staff on Leave, each defaulting to 0 if no data exists. The table also includes entities (business units) and regions, enabling users to efficiently track ticket volumes and staff activity across different locations and departments.
			\|-
			\|4. Total NCR Reports by Entity and Region
			\|Total NCR's =
			COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[id]), 0)
			\|The Total NCRs metric counts unique Non-Conformance Reports (NCRs) by tallying distinct ticket IDs from the 'NCR_page_datacaire_tickets' dataset, defaulting to 0 if no unique IDs exist.
			Displayed as an area chart, where the x-axis represents time (e.g., dates), and the y-axis shows the count of unique NCRs. The chart is segmented by entities (business units) and regions, with each area representing the NCR count for a specific entity-region combination, allowing users to visualize trends and compare non-conformance activity across different entities and regions over time.
	\|}		\|}

Stanley.songok at 11:22, 15 August 2025

2025-08-15T11:22:59Z

← Older revision		Revision as of 13:22, 15 August 2025
Line 39:		Line 39:
	!Description		!Description
	\|-		\|-
	\|		\|1.Total NCRs Raised By Entity, Region and Dates
	\|		\|Total NCR's =
	\|		COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[id]), 0)
			\|The Total NCRs metric shows the number of unique Non-Conformance Reports (NCRs) by counting distinct ticket IDs from the 'NCR_page_datacaire_tickets' dataset. If no unique IDs are found, it defaults to 0.
			The table displays Total NCRs alongside dates, entities, and regions. Each row shows the count of unique NCRs for a specific date, entity, and region, making it easy to track non-conformance trends across different time periods and locations.
			\|-
			\|2. Number of Tickets By Creation Dates
			\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)
			\|The Total Tickets metric counts all ticket IDs in the 'NCR_page_datacaire_tickets' dataset, representing the total number of tickets created.
			Displayed in a donut chart, where each segment shows the proportion of tickets created by individual users, allowing easy comparison of ticket creation activity by user.
			\|-
			\|3.Staff and Ticket Metrics Table
			\|Total Tickets=COUNT('NCR_page_datacaire_tickets'[id)
			\|The Staff and Ticket Metrics Table offers a concise overview of ticket and staff-related data. It displays the total number of tickets from the 'NCR_page_datacaire_tickets' dataset, alongside staff metrics from the 'NCR Database Combined' dataset, including Staffed Rostered (scheduled staff), Staff Attended (staff who worked), and Staff on Leave, each defaulting to 0 if no data exists. The table also includes entities (business units) and regions, enabling users to efficiently track ticket volumes and staff activity across different locations and departments.
	\|}		\|}

Hendry.mwamburi at 10:20, 15 August 2025

2025-08-15T10:20:14Z

← Older revision		Revision as of 12:20, 15 August 2025
Line 18:		Line 18:
	!Transformations		!Transformations
	\|-		\|-
			\|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.
			\|-
			\|SharePoint Tables =<nowiki>https://dcbiaero.sharepoint.com/sites/NCRDatabase/</nowiki>
			\|'''Purpose:''' Connects to the NCR Database stored on SharePoint and retrieves all available tables and lists.
			'''Details:''' Uses SharePoint API version 2.0 and loads all views in the site. Enables access to structured NCR (Non-Conformance Report) data for further transformation and reporting in Power BI.

			'''Usage:''' This source is used to supplement other datasets with NCR-related metadata or additional ticket details not available in the primary API.
	\|}		\|}

David.weller at 12:46, 14 August 2025

2025-08-14T12:46:30Z

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

	== Calculations ==		== Calculations ==
			[[File:Report-ncrpage-reportanalysis.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:17:09Z

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
|-
|
|
|
|}