--- alias: user-guide-business-intelligence-dashboard-maintenance-history grafana_json: Library/Build/ConfigFiles/Grafana/MES/dashboards/MaintenanceHistory.json tags: - dashboard description: "This dashboard visualizes maintenance history data, tracking system uptime and repair times across resources" --- # Maintenance History Dashboard ## Overview This dashboard provides information about the **Maintenance History** for one or more **Resources**. ## Folder * Resource History ## Database * DWH (queried via Cube using GraphQL) * CDM (queried via OData) ## Data * Mean Time Between Failures (MTBF) * Mean Time To Recovery (MTTRec) * Mean Time To Acknowledge (MTTA) * Mean Time To Repair (MTTRep) ## Example ![Screenshot showing a maintenance history dashboard with various charts and graphs.](../images/maintenance_history_dashboard_01.png) ![Screenshot showing a system maintenance history dashboard with various metrics and graphs.](../images/maintenance_history_dashboard_02.png) ## Data Breakdown | KPI | Description | Formula |Datasource | | - | ----------------- | --- |-------| | **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]]| | **Mean Time To Acknowledge (MTTA)** | Indicates the average delay between failure detection and the start of the response. In other words, it is the delay between the time a Resource changes to Unscheduled/Scheduled Down states and the time it takes to start a Corrective Maintenance Activity Order. | Begin Repair Time - Acknowledge Time |`resource_maintenance` in [[user-guide-resourcecube]]| | **Mean Time To Repair (MTTRep)** | Indicates the average time that it takes to physically fix the problem once work has begun. This means that it measures the time between the start and the completion of a Corrective Maintenance Activity Order. | Total Time to Fix Maintenance Activity |`resource_maintenance` in [[user-guide-resourcecube]]| ## Data Visualization | Panel | Description | Datasource | |-------|---------------|-------| | **Evolution Per Day** | Displays the daily trend of MTBF, MTTRec, MTTA, and MTTRep over the selected time range.| `resource_states` and `resource_maintenance` in [[user-guide-resourcecube]]| | **KPI Performance** | Displays the mean values of the selected KPI over the defined time range. | `resource_states` or `resource_maintenance` in [[user-guide-resourcecube]]| | **Maintenance History View** | Lists the Maintenance History for the selected filters. The Maintenance History includes information on Maintenance Plans and Activities. | Data Sets MaintenanceOrder (CDM)| ## Entity Filters ### Single Selection * Enterprise, Site ### Multiple/All Selection * Facility, Area, Resource Type, Model, Resource, Shift, Columns {% include-markdown 'includes/pages/dashboards_filter_options.md' %}