NCR - DataCair Tickets

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