Performance Page

Summary


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)
Resolution Status	Filters data by the status of a case, issue, or task (e.g. Resolved, Not Resolved).


Query	Transformations
Entity table API link =https://customer-service.datacair.com/api/ticket/customfield/6	API Endpoint: `https://customer-service.datacair.com/api/ticket/customfield/6` 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/5	API Endpoint: `https://customer-service.datacair.com/api/ticket/customfield/5` Purpose: Retrieves the Entity 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/4	API Endpoint: `https://customer-service.datacair.com/api/ticket/customfield/4` Purpose: Retrieves Corrective Action custom field values for tickets. Default Behavior: The API returns a maximum of 50 records per request unless otherwise specified.


Columns	Calculation	Description
1. Total tickets by resolution time	Total Tickets = DISTINCTCOUNT ( 'Performance and Root Cause'[Ticket Number] )	This metric tracks the number of support or service tickets resolved within specified time intervals. It provides insight into the efficiency of the resolution process, helping identify trends, bottlenecks, and opportunities for process improvement.
2. Total tickets by Root cause	Total Tickets = DISTINCTCOUNT ( 'Performance and Root Cause'[Ticket Number] )	This metric measures the number of tickets categorized by their underlying root cause. It is used to identify recurring issues, prioritize fixes, and prevent similar incidents in the future.
3. Total tickets by Corrective Action	Total Tickets = DISTINCTCOUNT ( 'Performance and Root Cause'[Ticket Number] )	This metric measures the number of tickets categorized by the corrective action taken to resolve them. It helps evaluate the effectiveness of remediation strategies and supports continuous improvement in service delivery.