--- alias: user-guide-business-intelligence-dashboard-quality-information grafana_json: /Library/Build/ConfigFiles/Grafana/MES/dashboards/QualityInformation.json tags: - dashboards - quality information description: "This dashboard provides data insights into product quality, enabling analysis and process improvement" --- # Quality Information ## Overview The **Quality Information** dashboard provides insights into product quality performance. It helps detect recurring quality issues, prioritize root-cause analysis, and improve overall process reliability. ## Folder Quality. ## Database - **CDM** (queried via OData). - **DWH** (queried via OData and Cubes using GraphQL). ## Data - **Yield** - **Loss Reasons** - **Hold Reasons** ## Example ![Example of the Quality Information dashboard](../images/quality_information_dashboard.png) ## Data Breakdown | KPI | Description | Formula | Datasource | | --- | ----------- | ------- | ---------- | | **Yield (%)** | Share of processed material (non-scrap, non-hold) that becomes usable output. | `(Good Units ÷ Total Units) × 100` | `material_movement` cube from [[user-guide-materialcube]] | | **Product Losses per Day** | Average daily quantity of lost products. | `Sum of Product Losses ÷ Number of days with losses` | `MaterialLossBonus` table (DWH) in [[dataplatform-dataset-materiallossbonus]] | | **Product Holds per Day** | Average daily quantity of held products. | `Sum of Product Holds ÷ Number of days with holds` | `Material.HoldRelease` table (CDM) from [[dataplatform-ioteventdefinition-dataset-holdrelease]]| ## Data Visualization | Panel | Description | Threshold Values | Datasource | |-------|-------------|------------------|------------| | **Yield Evolution Over Time** | Bar chart showing daily yield trends within the selected period. | Yield should be as high as possible (green >90%, yellow 80–90%, red <80%). | `material_movement` cube in [[user-guide-materialcube]] | | **Top Loss Reasons by Occurrences** | Horizontal bar chart showing most frequent loss reasons. | Top reason highlighted in red. | `MaterialLossBonus` table (DWH) in [[dataplatform-dataset-materiallossbonus]] | | **Top Hold Reasons by Occurrences** | Horizontal bar chart showing most frequent hold reasons. | Top reason highlighted in red. | `Material.HoldRelease` table (CDM) from [[dataplatform-ioteventdefinition-dataset-holdrelease]] | | **Top Loss Reasons by Quantity** | Horizontal bar chart showing reasons with the highest absolute loss quantities. | Largest reason highlighted in red. | `MaterialLossBonus` table (DWH) in [[dataplatform-dataset-materiallossbonus]] | | **Top Hold Reasons by Quantity** | Horizontal bar chart showing reasons with the highest absolute hold quantities. | Largest reason highlighted in red. | `Material.HoldRelease` table (CDM) from [[dataplatform-ioteventdefinition-dataset-holdrelease]] | | **Yield KPI** | KPI card showing the overall yield for the selected period. | Green >90%, Yellow 80–90%, Red <80%. | `material_movement` cube in [[user-guide-materialcube]] | | **Product Losses per Day** | KPI card showing the average number of products lost per day. | As low as possible. | `MaterialLossBonus` table (DWH) in [[dataplatform-dataset-materiallossbonus]] | | **Product Holds per Day** | KPI card showing the average number of products held per day. | As low as possible. | `Material.HoldRelease` table (CDM) from [[dataplatform-ioteventdefinition-dataset-holdrelease]] | ## Entity Filters Single selection: - Enterprise - Site - Facility - Material Units - Show Top (5, 10, 20) - pertains to how many loss/hold reasons are presented in the graphs. Multiple/All selection: - Product Group - Product - Step {% include-markdown 'includes/pages/dashboards_filter_options.md' %}