Documentation
Grafana Dashboard
Grafana Dashboard
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": {
"type": "grafana",
"uid": "-- Grafana --"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
"id": 20,
"links": [],
"panels": [
{
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 6,
"x": 0,
"y": 0
},
"id": 5,
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "\n<div style=\"background: linear-gradient(90deg, #ff9999, #FFA500); padding: 10px; border-radius: 8px; text-align: center;\">\n <div style=\"font-size: 15px; color: black; margin-top: 5px; font-weight: bold;\">\n Time: ${__to:date:HH:mm:ss}\n </div>\n <div style=\"font-size: 15px; color: black; margin-top: 2px; font-weight: bold;\">\n Date: ${__to:date:YYYY-MM-DD}\n </div>\n</div>\n\n",
"mode": "html"
},
"pluginVersion": "11.3.0+security-01",
"title": "",
"transparent": true,
"type": "text"
},
{
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 18,
"x": 6,
"y": 0
},
"id": 2,
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<div style=\"background: linear-gradient(90deg, #ff9999, #FFA500); padding: 10px; border-radius: 8px; text-align: center;\">\n<div style=\"font-size: 18px; color: black; font-weight: bold;\">\nIIoT Development Platform\n</div>",
"mode": "markdown"
},
"pluginVersion": "11.3.0+security-01",
"title": "",
"transparent": true,
"type": "text"
},
{
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 18,
"x": 6,
"y": 2
},
"id": 17,
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<div style=\"background: linear-gradient(90deg, #FFD700, #FFA500); padding: 10px; border-radius: 8px; text-align: center;\">\n<div style=\"font-size: 18px; color: black; font-weight: bold;\">\nCompleted Production Lists\n</div>",
"mode": "markdown"
},
"pluginVersion": "11.3.0+security-01",
"title": "",
"transparent": true,
"type": "text"
},
{
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 9,
"w": 6,
"x": 0,
"y": 3
},
"id": 3,
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<img src=\"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcS6jzU-bzJ1OYLkx2tRVWiO48zDF3hh2gU1Ig&s>\nalt=\"IKTBN Sepang Logo\" width=\"330\" height=\"280\" />",
"mode": "html"
},
"pluginVersion": "11.3.0+security-01",
"title": "",
"transparent": true,
"type": "text"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"align": "center",
"cellOptions": {
"type": "auto"
},
"filterable": true,
"inspect": false
},
"mappings": [
{
"options": {
"done": {
"color": "green",
"index": 0,
"text": "Done"
},
"progress": {
"color": "orange",
"index": 1,
"text": "In Progress"
},
"to_close": {
"color": "orange",
"index": 2,
"text": "To Close"
}
},
"type": "value"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "semi-dark-blue",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 18,
"x": 6,
"y": 4
},
"id": 16,
"options": {
"cellHeight": "sm",
"footer": {
"countRows": false,
"enablePagination": true,
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"frameIndex": 0,
"showHeader": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "mo_workorders",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT \n \"production_id\",\n \"production_name\",\n \"workorder_name\",\n \"workorder_id\",\n \"workcenter_code\",\n \"workcenter_name\",\n \"production_qty\",\n \"production_state\",\n \"workorder_state\",\n \"duration_expected\"\nFROM \"mo_workorders\"\nWHERE \n time > now() - 30d\n AND (\"production_state\" = 'to_close' OR \"production_state\" = 'done')\nORDER BY time DESC\nLIMIT 20\n\n",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "",
"transformations": [
{
"id": "concatenate",
"options": {}
},
{
"id": "organize",
"options": {
"excludeByName": {
"mo_workorders.duration_expected · Time": true,
"mo_workorders.production_id": true,
"mo_workorders.production_id · Time": true,
"mo_workorders.production_name · Time": true,
"mo_workorders.production_qty · Time": true,
"mo_workorders.production_state · Time": true,
"mo_workorders.workcenter_code": true,
"mo_workorders.workcenter_code · Time": true,
"mo_workorders.workcenter_name · Time": true,
"mo_workorders.workorder_id": true,
"mo_workorders.workorder_id · Time": true,
"mo_workorders.workorder_name": true,
"mo_workorders.workorder_name · Time": true,
"mo_workorders.workorder_state": true,
"mo_workorders.workorder_state · Time": true
},
"includeByName": {},
"indexByName": {
"mo_workorders.duration_expected": 5,
"mo_workorders.duration_expected · Time": 9,
"mo_workorders.production_id": 11,
"mo_workorders.production_id · Time": 10,
"mo_workorders.production_name": 0,
"mo_workorders.production_name · Time": 12,
"mo_workorders.production_qty": 4,
"mo_workorders.production_qty · Time": 13,
"mo_workorders.production_state": 7,
"mo_workorders.production_state · Time": 14,
"mo_workorders.workcenter_code": 2,
"mo_workorders.workcenter_code · Time": 15,
"mo_workorders.workcenter_name": 3,
"mo_workorders.workcenter_name · Time": 16,
"mo_workorders.workorder_id": 8,
"mo_workorders.workorder_id · Time": 17,
"mo_workorders.workorder_name": 1,
"mo_workorders.workorder_name · Time": 18,
"mo_workorders.workorder_state": 6,
"mo_workorders.workorder_state · Time": 19
},
"renameByName": {
"mo_workorders.duration_expected": "Expected Duration",
"mo_workorders.production_name": "Job Order",
"mo_workorders.production_qty": "Production Qty",
"mo_workorders.production_state": "Job Status",
"mo_workorders.workcenter_code": "Machine Code",
"mo_workorders.workcenter_name": "Machine Name",
"mo_workorders.workorder_id": "",
"mo_workorders.workorder_name": "Work Order",
"mo_workorders.workorder_state": "Work Status"
}
}
}
],
"transparent": true,
"type": "table"
},
{
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 24,
"x": 0,
"y": 12
},
"id": 15,
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<div style=\"background: linear-gradient(90deg, #FFD700, #FFA500); padding: 10px; border-radius: 8px; text-align: center;\">\n<div style=\"font-size: 18px; color: black; font-weight: bold;\">\nCurrent Work Order Details\n</div>",
"mode": "markdown"
},
"pluginVersion": "11.3.0+security-01",
"title": "",
"transparent": true,
"type": "text"
},
{
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 11,
"x": 0,
"y": 14
},
"id": 36,
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<div style=\"background: linear-gradient(90deg, #FFD700, #FFA500); padding: 10px; border-radius: 8px; text-align: center;\">\n<div style=\"font-size: 18px; color: black; font-weight: bold;\">\nFANUC_CNC_0\n</div>",
"mode": "markdown"
},
"pluginVersion": "11.3.0+security-01",
"title": "",
"transparent": true,
"type": "text"
},
{
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 11,
"x": 13,
"y": 14
},
"id": 37,
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<div style=\"background: linear-gradient(90deg, #FFD700, #FFA500); padding: 10px; border-radius: 8px; text-align: center;\">\n<div style=\"font-size: 18px; color: black; font-weight: bold;\">\nFANUC_CNC_1\n</div>",
"mode": "markdown"
},
"pluginVersion": "11.3.0+security-01",
"title": "",
"transparent": true,
"type": "text"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 3,
"x": 0,
"y": 16
},
"id": 22,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"order_name\")\nFROM \"oee_metrics\"\nWHERE \"workcenter_code\" = '000_0'\nAND time > now() - 1m\n",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"order_name"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Current MO Reference",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 3,
"x": 3,
"y": 16
},
"id": 24,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"workcenter_name\")\nFROM \"oee_metrics\"\nWHERE \"workcenter_code\" = '000_0'\n AND time > now() - 1m\n",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"workcenter_name"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Current Work Center",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {
"workcenter_name {workorder_id=\"2\", workorder_name=\"Test2\"}": ""
}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 6,
"y": 16
},
"id": 29,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"product_qty\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_0'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"product_qty"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Planned Qty",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [
{
"options": {
"done": {
"color": "green",
"index": 1,
"text": "Finished"
},
"pending": {
"color": "orange",
"index": 4,
"text": "In Progress"
},
"progress": {
"color": "orange",
"index": 0,
"text": "In Progress"
},
"ready": {
"color": "orange",
"index": 3,
"text": "In Progress"
},
"waiting": {
"color": "orange",
"index": 2,
"text": "In Progress"
}
},
"type": "value"
}
],
"noValue": "-",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 3,
"x": 8,
"y": 16
},
"id": 34,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"workorder_state\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_0'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"workorder_state"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Work Order Status",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {
"workcenter_name {workorder_id=\"2\", workorder_name=\"Test2\"}": ""
}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 3,
"x": 13,
"y": 16
},
"id": 23,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"order_name\")\nFROM \"oee_metrics\"\nWHERE \"workcenter_code\" = '000_1'\nAND time > now() - 1m\n",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"order_name"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Current MO Reference",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 3,
"x": 16,
"y": 16
},
"id": 25,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"workcenter_name\")\nFROM \"oee_metrics\"\nWHERE \"workcenter_code\" = '000_1'\n AND time > now() - 1m\n",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"workcenter_name"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Current Work Center",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {
"workcenter_name {workorder_id=\"2\", workorder_name=\"Test2\"}": ""
}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 19,
"y": 16
},
"id": 31,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"product_qty\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_1'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"product_qty"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Planned Qty",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [
{
"options": {
"done": {
"color": "green",
"index": 1,
"text": "Finished"
},
"pending": {
"color": "orange",
"index": 4,
"text": "In Progress"
},
"progress": {
"color": "orange",
"index": 0,
"text": "In Progress"
},
"ready": {
"color": "orange",
"index": 3,
"text": "In Progress"
},
"waiting": {
"color": "orange",
"index": 2,
"text": "In Progress"
}
},
"type": "value"
}
],
"noValue": "-",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 3,
"x": 21,
"y": 16
},
"id": 35,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"workorder_state\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_1'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"workorder_state"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Work Order Status",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {
"workcenter_name {workorder_id=\"2\", workorder_name=\"Test2\"}": ""
}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 3,
"x": 0,
"y": 20
},
"id": 26,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"workorder_name\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_0'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"workorder_name"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Current Work Order Name",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 3,
"x": 3,
"y": 20
},
"id": 28,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"product_name\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_0'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"product_name"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Product Name",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 6,
"y": 20
},
"id": 32,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"actual_qty\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_0'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"actual_qty"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Actual Qty",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 3,
"x": 13,
"y": 20
},
"id": 27,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"workorder_name\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_1'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"workorder_name"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Current Work Order Name",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 3,
"x": 16,
"y": 20
},
"id": 30,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"product_name\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_1'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"product_name"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Product Name",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"noValue": "...",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "purple",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 19,
"y": 20
},
"id": 33,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/.*/",
"values": false
},
"showPercentChange": false,
"text": {},
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"actual_qty\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_1'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"actual_qty"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Actual Qty",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"transparent": true,
"type": "stat"
},
{
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 11,
"x": 0,
"y": 24
},
"id": 14,
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<div style=\"background: linear-gradient(90deg, #FFD700, #FFA500); padding: 10px; border-radius: 8px; text-align: center;\">\n<div style=\"font-size: 18px; color: black; font-weight: bold;\">\nCurrent Production Overall Equipment Effectiveness (OEE)\n</div>",
"mode": "markdown"
},
"pluginVersion": "11.3.0+security-01",
"title": "",
"transparent": true,
"type": "text"
},
{
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 11,
"x": 13,
"y": 24
},
"id": 38,
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<div style=\"background: linear-gradient(90deg, #FFD700, #FFA500); padding: 10px; border-radius: 8px; text-align: center;\">\n<div style=\"font-size: 18px; color: black; font-weight: bold;\">\nCurrent Production Overall Equipment Effectiveness (OEE)\n</div>",
"mode": "markdown"
},
"pluginVersion": "11.3.0+security-01",
"title": "",
"transparent": true,
"type": "text"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 2,
"mappings": [],
"noValue": "%",
"thresholds": {
"mode": "percentage",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 40
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "green",
"value": 85
},
{
"color": "dark-green",
"value": 100
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 3,
"x": 0,
"y": 26
},
"id": 6,
"options": {
"minVizHeight": 75,
"minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
"firstNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"sizing": "auto"
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"availability\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_0'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"availability"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Availability",
"transparent": true,
"type": "gauge"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 2,
"mappings": [],
"noValue": "%",
"thresholds": {
"mode": "percentage",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 40
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "green",
"value": 85
},
{
"color": "dark-green",
"value": 100
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 3,
"x": 3,
"y": 26
},
"id": 9,
"options": {
"minVizHeight": 75,
"minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
"firstNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"sizing": "auto"
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"performance\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_0'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"performance"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Performance",
"transparent": true,
"type": "gauge"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 2,
"mappings": [],
"noValue": "%",
"thresholds": {
"mode": "percentage",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 40
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "green",
"value": 85
},
{
"color": "dark-green",
"value": 100
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 5,
"x": 6,
"y": 26
},
"id": 8,
"options": {
"minVizHeight": 75,
"minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
"firstNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"sizing": "auto"
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"oee\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_0'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"oee"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "OEE",
"transparent": true,
"type": "gauge"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 2,
"mappings": [],
"noValue": "%",
"thresholds": {
"mode": "percentage",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 40
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "green",
"value": 85
},
{
"color": "dark-green",
"value": 100
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 3,
"x": 13,
"y": 26
},
"id": 39,
"options": {
"minVizHeight": 75,
"minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
"firstNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"sizing": "auto"
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"availability\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_1'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"availability"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Availability",
"transparent": true,
"type": "gauge"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 2,
"mappings": [],
"noValue": "%",
"thresholds": {
"mode": "percentage",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 40
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "green",
"value": 85
},
{
"color": "dark-green",
"value": 100
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 3,
"x": 16,
"y": 26
},
"id": 40,
"options": {
"minVizHeight": 75,
"minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
"firstNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"sizing": "auto"
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"performance\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_1'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"performance"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "Performance",
"transparent": true,
"type": "gauge"
},
{
"datasource": {
"type": "influxdb",
"uid": "ben0m9nva7fgga"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 2,
"mappings": [],
"noValue": "%",
"thresholds": {
"mode": "percentage",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 40
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "green",
"value": 85
},
{
"color": "dark-green",
"value": 100
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 5,
"x": 19,
"y": 26
},
"id": 41,
"options": {
"minVizHeight": 75,
"minVizWidth": 75,
"orientation": "auto",
"reduceOptions": {
"calcs": [
"firstNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"sizing": "auto"
},
"pluginVersion": "11.3.0+security-01",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "ef1yzsqeztfr4d"
},
"groupBy": [],
"measurement": "oee_metrics",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT LAST(\"oee\") \nFROM \"oee_metrics\" \nWHERE \"workcenter_code\" = '000_1'\n AND time > now() - 1m",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"oee"
],
"type": "field"
}
]
],
"tags": []
}
],
"title": "OEE",
"transparent": true,
"type": "gauge"
}
],
"preload": false,
"refresh": "5s",
"schemaVersion": 40,
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now-5m",
"to": "now"
},
"timepicker": {},
"timezone": "Asia/Kuala_Lumpur",
"title": "CNC Monitoring Dashboard (2 machines)",
"uid": "CNC_dashboard",
"version": 1,
"weekStart": ""
}