--- alias: user-guide-business-intelligence-dashboard-resource-oee-history tags: - dashboard grafana_json: Library\Build\ConfigFiles\Grafana\MES\dashboards\ResourceOEEHistory.json description: "This dashboard tracks resource performance using Overall Equipment Effectiveness data and historical trends" --- # Resource OEE History ## Overview The **Resource OEE History** dashboard provides a comprehensive view of the historical performance of **Resources** using the Overall Equipment Effectiveness (OEE) metric. ## Folder * Performance ## Database * DWH (queried via Cube using GraphQL) ## Data * OEE (%) * Availability (%) * Quality (%) * Performance (%) * Rate Efficiency * Operational Efficiency (%) ## Example ![Resource OEE History 1](../images/resource_oee_grafana.png) ![Resource OEE History 2](../images/resource_oee_grafana_1.png) ![Resource OEE History 3](../images/resource_oee_grafana_2.png) ## Data Breakdown | KPI | Description | Formula | Datasource | | - | ------ | --- | ---- | | **OEE** | Measures equipment effectiveness based on Availability, Performance, and Quality. | Availability x Performance x Quality | `resource_states_non_working_times` in [[user-guide-resourcecube]]| | **Availability** | Indicates how much of the scheduled production time a Resource was operating, excluding downtime. | Operating Time ÷ Potential Production Time x 100 | `resource_states_non_working_times` in [[user-guide-resourcecube]]| | **Quality** | Measures the percentage of good (non-defective) units produced compared to the total units processed. | Total Processed Primary Quantity ÷ (Total Processed Primary Quantity + Total Primary Quantity Losses) x 100 | `material_movement` in [[user-guide-materialcube#material-movement]]| | **Performance** | Measures how efficiently a Resource operates by comparing the actual operating speed to its ideal cycle time during productive time. | Ideal Cycle Time ÷ Operating Time x 100 | `resource_states_non_working_times` in [[user-guide-resourcecube]]|| | **Rate Efficiency** | Indicates the efficiency of the operating speed of a Resource compared to its ideal rate during the period. | Ideal Cycle Time ÷ Net Operating Time x 100 | `resource_states_non_working_times` in [[user-guide-resourcecube]]| | **Operational Efficiency** | Measures the proportion of actual productive time a Resource uses compared to total operating time available, excluding planned and unplanned downtime. | Net Operating Time ÷ Operating Time x 100 | `resource_states_non_working_times` in [[user-guide-resourcecube]]| ## Data Visualization | Panel | Description | Threshold Values | Datasource | |-------|-------------|------------------|------------| |**OEE overtime**| Time Series displaying the evolution of Availability, Performance, Quality, and OEE across the selected time period. | N/A |`resource_states_non_working_times` in [[user-guide-resourcecube]] and `material_movement` in [[user-guide-materialcube#material-movement]]| |**OEE components**| Circular Bar Chart displaying KPIs: OEE, Availability, Performance, and Quality. | N/A | `resource_states_non_working_times` in [[user-guide-resourcecube]] and `material_movement` in [[user-guide-materialcube#material-movement]]| |**Performance components**| Circular Bar Chart displaying KPIs: Performance, Rate Efficiency, and Operational Efficiency. | N/A | `resource_states_non_working_times` in [[user-guide-resourcecube]]| |**Resource OEE History** | Table showing historical OEE values | Colors representing ranges: red (0–70%), yellow (70–100%), green (100%) | `resource_states_non_working_times` in [[user-guide-resourcecube]] | ## Entity Filters ### Single selection * Enterprise * Site ### Multiple/All selection * Facility * Area * Resource * Shift * Model * Resource Type {% include-markdown 'includes/pages/dashboards_filter_options.md' %}