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
|
