--- alias: user-guide-business-intelligence-dashboard-scrap-information grafana_json: /Library/Build/ConfigFiles/Grafana/MES/dashboards/ScrapInformation.json tags: - dashboards - scrap information description: "This dashboard analyzes material loss data, revealing key causes and quantities across various production factors" --- # Scrap Information ## Overview The **Scrap Information** dashboard provides insights about **Material** losses in the system. It supports production analysis, identification of recurring scrap causes, and prioritization of areas with the most significant impact on material yield. ## Folder Quality. ## Database - **DWH** (queried via OData). ## Data - **Top Material Losses** - **Top Loss Reasons** ## Example ![Example of the Scrap Information dashboard](../images/scrap_information_dashboard.png) ## Data Breakdown | KPI | Description | Formula | Datasource | | --- | ----------- | ------- | ---------- | | **Top Loss Reasons** | Most frequent causes of losses by quantity. | Sum of loss quantity (`Change_PrimaryQty`) grouped by reason (`Change_Reason`). | `MaterialLossBonus` table in [[dataplatform-dataset-materiallossbonus]] | | **Top Material Losses** | Materials with the highest total absolute loss quantity. | Sum of loss quantity (`Change_PrimaryQty`) grouped by material (`Material_Name`). | `MaterialLossBonus` table in [[dataplatform-dataset-materiallossbonus]] | ## Data Visualization | Panel | Description | Threshold Values | Datasource | |-------|-------------|------------------|------------| | **Top Loss Reasons** | Horizontal bar and cumulative line chart showing the top loss reasons. | The highest-ranking bar is highlighted in red. Bars above the 80% cumulative threshold highlight the reasons with the most impact. | `MaterialLossBonus` table in [[dataplatform-dataset-materiallossbonus]] | | **Top Material Losses** | Horizontal bar and cumulative line chart showing the top materials by scrap quantity.| The highest-ranking bar is highlighted in red. Bars above the 80% cumulative threshold highlight the materials with the most impact. | `MaterialLossBonus` table in [[dataplatform-dataset-materiallossbonus]] | | **History View** | Breakdown of all reported losses, including Date, Shift, Facility, Area, Step, Material, Type, Form, Loss Reason, and Loss Quantity. | N/A | `MaterialLossBonus` table in [[dataplatform-dataset-materiallossbonus]] | ## Entity Filters Single selection: - Enterprise - Site - Show Top (10, 20, 50, 100) - pertains to how many materials and reasons are presented in the graphs. Multiple/All selection: - Facility - Area - Step Type - Step - Product - Material Type - Material Form - Material Units - Shift Definition - Shift {% include-markdown 'includes/pages/dashboards_filter_options.md' %}