Performance Page

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

Data Transformation Applied

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.

Calculations

Columns	Calculation	Description
Resolved Tickets By Resolution Time	Total Tickets = DISTINCTCOUNT ( 'Performance and Root Cause'[Ticket Number] )	These displays resolved tickets within resolved time category.
2. Total tickets by Root cause	Total Tickets = DISTINCTCOUNT ( 'Performance and Root Cause'[Ticket Number] )	These displays count of tickets by there corresponding root cause via bar chart.
3. Total tickets by Corrective Action	Total Tickets = DISTINCTCOUNT ( 'Performance and Root Cause'[Ticket Number] )	These displays count of tickets by there corresponding corrective action visualized by bar chart