--- alias: user-guide-business-intelligence-dashboard-resource-efficiency grafana_json: Library/Build/ConfigFiles/Grafana/MES/dashboards/ResourceEfficiency.json tags: - dashboard description: "This dashboard tracks resource performance and efficiency, providing insights into operational status and downtime" --- # Resource Efficiency ## Overview The **Resource Efficiency** dashboard provides a real-time overview of the performance and efficiency of one or more **Resources** over a selected period of time. ## Folder * Performance ## Database * DWH (queried via Cube using GraphQL) ## Data * OEE - Overall Equipment Effectiveness (%) * Availability (%) * Quality (%) * Performance (%) * Mean Time Between Failures (MTBF) * Mean Time To Recovery (MTTRec) * Operating Time/Down Time * Resource States ## Example ![Resource Efficiency](../images/resource_efficiency.png) ## Data Breakdown | KPI | Description | Formula | Datasource | | - | ------ | --- | ------ | | **OEE - Overall Equipment Effectiveness** | 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]]| | **Mean Time Between Failures (MTBF)** | Quantifies the average uptime of a system before a failure occurs. It reflects reliability - the higher the MTBF, the more time the equipment stays operational between failures. The data shown in this KPI is the average of the time that a Resource spends between Unscheduled/Scheduled Down states. | Operating Time ÷ Number of Failures | `resource_states` in [[user-guide-resourcecube]]| | **Mean Time To Recovery (MTTRec)** | Reflects how long, on average, it takes to recover from a failure, that is, how long the Resource remains unavailable. The data shown in this KPI is the average of the total downtime that a Resource spends between Unscheduled/Scheduled Down states. | Total Downtime ÷ Number of Failures |`resource_states` in [[user-guide-resourcecube]]| | **Operating Time** | Shows the time the Resource is running. Operating Time is represented in green. | N/A |`resource_states_non_working_times` in [[user-guide-resourcecube]]| | **Down Time** | Shows the time the Resource is down. Down Time is represented in red. | N/A |`resource_states_non_working_times` in [[user-guide-resourcecube]]| | **Resource States** | Shows the time the Resource is in each state (Productive, Engineering, Standby, Unscheduled Downtime, and Scheduled Downtime). | N/A |`resource_states_non_working_times` in [[user-guide-resourcecube]]| For more information, see [[user-guide-resource-index]]. ## Data Visualization | Panel | Description | Threshold Values | Datasource | |-------|------| ------ | ------------| | **OEE - Overall Equipment Effectiveness** | Measures equipment effectiveness based on Availability, Performance, and Quality. | Color threshold:
- Values below 70% are red.
- Values between 70% and 80% are yellow.
- Values above 80% are not highlighted. | `resource_states_non_working_times` in [[user-guide-resourcecube]]| | **Availability** | Indicates how much of the scheduled production time a resource was operating, excluding downtime. | Color threshold:
- Values below 80% are red.
- Values between 80% and 90% are yellow.
- Values above 90% are not highlighted. | `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. | Color threshold:
- Values below 80% are red.
- Values between 80% and 90% are yellow.
- Values above 90% are not highlighted. | `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. | Color threshold:
- Values below 80% are red.
- Values between 80% and 90% are yellow.
- Values above 90% are not highlighted. | `resource_states_non_working_times` in [[user-guide-resourcecube]]| | **Mean Time Between Failures (MTBF)** | Quantifies the average uptime of a system before a failure occurs. It reflects reliability - the higher the MTBF, the more time the equipment stays operational between failures. The data shown in this KPI is the average of the time that a Resource spends between Unscheduled/Scheduled Down states. | N/A | `resource_states` in [[user-guide-resourcecube]]| | **Mean Time To Recovery (MTTRec)** | Reflects how long, on average, it takes to recover from a failure, that is, how long the Resource remains unavailable. The data shown in this KPI is the average of the total downtime that a Resource spends between Unscheduled/Scheduled Down states. | N/A |`resource_states` in [[user-guide-resourcecube]]| | **Operating Time vs Down Time** | This line chart shows the balance between the time the Resource is running versus the time the Resource is down. Operating Time is represented in green, and Down Time in red. | N/A |`resource_states_non_working_times` in [[user-guide-resourcecube]]| | **Maintenance** | This bar chart tracks two maintenance metrics over time: MTBF and MTTRec. Together, they give a picture of equipment reliability and repair efficiency. | N/A |`resource_states` in [[user-guide-resourcecube]]| | **Time at State** | This pie chart shows how the total time of the Resources is distributed across the different states: Productive, Engineering, Standby, Unscheduled Downtime, and Scheduled Downtime. | N/A |`resource_states_non_working_times` in [[user-guide-resourcecube]]| ## Entity Filters ### Single Selection * Enterprise, Site ### Multiple/All Selection * Facility, Area, Resource {% include-markdown 'includes/pages/dashboards_filter_options.md' %}