NCR - DataCair Tickets: Difference between revisions

Latest revision as of 10:21, 30 January 2026

Summary

This Power BI report provides a centralized view of service ticket performance across entities. Its API-sourced data has calculated metrics, and user-interactive filters to enable monitoring of resolution efficiency.

Filters


Filter	Description
Date picker	Allows users to filter the dataset by a specific date or date range.
Entity slicer	Enables users to filter the report by entity ( Business unit)
Region slicer	Enables users to filter the report by region

Data Transformation Applied


Query	Transformations
Datacair tickects table API link =https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000	API Endpoint: `https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000` Purpose: Retrieves comprehensive ticket information for department ID 4, including metadata and key lifecycle fields. The `limit` 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


Columns	Calculation	Description
Total NCR's	COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)	Counts the number of unique `data.id` in NCR tickets. Returns 0 if there are no records
Total Transactions Affected	COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)	Counts the number of unique `data.id` in NCR tickets. Returns 0 if there are no records

@@ Line 8: / Line 8: @@
 !Description
 |-
-|Example filter
+|Date picker
-|Filter description
+|Allows users to filter the dataset by a specific date or date range.
+|-
+|Entity slicer
+|Enables users to filter the report by entity ( Business unit)
+|-
+|Region slicer
+|Enables users to filter the report by region
+|-
 |}
@@ Line 18: / Line 26: @@
 !Transformations
 |-
-|Example Query
+|Datacair tickects table API link =<nowiki>https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000</nowiki>
 |
-Example transformations
+* '''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.
 |}
@@ Line 30: / Line 40: @@
 !Description
 |-
-|Example
+|
-|Example calc
+# Total NCR's
-|Example description
+|COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)
+|Counts the number of unique <code>data.id</code> in NCR tickets. Returns 0 if there are no records
+|-
+|
+# Total Transactions  Affected
+|COALESCE(DISTINCTCOUNT('NCR_page_datacaire_tickets'[data.id]), 0)
+|Counts the number of unique <code>data.id</code> in NCR tickets. Returns 0 if there are no records
 |}