Entity Breakdown 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)
User	Allows report viewers to filter the dataset by the ticket requester or assignee

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