Entity Breakdown Page
Summary
The Non-Conformance Dashboard provides an interactive and consolidated view of service and operational non-conformance tickets. It supports performance monitoring, trend analysis, and root cause identification across multiple business entities.
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 |
|
| Datacair tickects table API link =https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000 |
|
Calculations
| Columns | Calculation | Description |
|---|---|---|
| 1. Total Non-Conformance Raised | Total Non-Conformance = DISTINCTCOUNT('Performance and Root Cause'[id]) | This measure calculates the total number of unique non-conformance records in the dataset by counting distinct ticket IDs. |
| 2. Total Non-Conformance Resolved | Total Non-Conformances Resolved = CALCULATE(COUNT('Performance and Root Cause'[status name]),'Performance and Root Cause'[status name]="Closed") | This measure counts the total number of non-conformance tickets that have been resolved, based on their status being marked as "Closed".
|
| 3. Total Non-Conformance Open | Total Non-Conformances Open = CALCULATE(COUNT('Performance and Root Cause'[status name]),'Performance and Root Cause'[status name]="Open") | This measure counts the total number of non-conformance tickets that are still open, based on their status being marked as "Open".
|
| 4. Total Non-Conformance Awaiting Reply | Total Non-Conformances Awaiting Reply = CALCULATE(COUNT('Performance and Root Cause'[status name]),'Performance and Root Cause'[status name]="Awaiting Reply") | This measure counts the total number of non-conformance tickets currently in the "Awaiting Reply" status, indicating that further information or action is required from the customer, stakeholder, or another party before resolution can proceed.
|
| 5. Average Resolution Time (Days) | Average Resolution Time (Days) =
AVERAGE ( 'Performance and Root Cause'[Days] ) |
This measure calculates the mean number of days taken to resolve non-conformance tickets, based on the difference between the ticket’s creation date and resolution date. |
| 6. Total Non-conformance by Category Name | Total Non-Conformance = DISTINCTCOUNT('Performance and Root Cause'[id]) | This visual displays the total count of non-conformance tickets grouped by their Category Name. Each bar represents a category, and the bar’s length corresponds to the number of tickets in that category. |
| 7. Total Non-conformance and MOM Growth% by Month Name | MoM Variance = [Total Non-Conformance]-[Last Month Tickets]
MoM Growth% = DIVIDE([MoM Variance],[Last Month Tickets]) Total Non-Conformance = DISTINCTCOUNT('Performance and Root Cause'[id]) |
This visual combines a clustered bar chart (showing total non-conformance counts per month) with a line chart (showing Month-over-Month growth percentage). It provides both absolute ticket volumes and their relative change over time in a single view. |
| 8. Total Non-Conformance by Root Cause | Total Non-Conformance = DISTINCTCOUNT('Performance and Root Cause'[id]) | This visual displays the total number of non-conformance cases categorized by their Root Cause, using a stacked bar chart. Each bar represents a grouping (such as entity, month, or category, depending on active filters), and each segment represents a specific root cause classification |
| 9. Total Non conformance by corrective action | Total Non-Conformance = DISTINCTCOUNT('Performance and Root Cause'[id]) | This visual presents the total number of non-conformance cases categorized by the Corrective Action taken, using a stacked bar chart. Each bar represents a grouping (such as entity, month, or category depending on filters), with each segment showing a specific corrective action classification. |
| 10. Total Non-Conformance by Action | Total Non-Conformance = DISTINCTCOUNT('Performance and Root Cause'[id]) | This visual presents the total number of non-conformance cases categorized by the Action taken against employee taken to resolve them, using a stacked bar chart. Each bar corresponds to a grouping (such as entity, month, or category, depending on active filters), and each colored segment within the bar represents a specific Action taken. |