Untitled
unknown
plain_text
2 years ago
331 kB
4
Indexable
{ "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": 2, "links": [], "liveNow": false, "panels": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "red", "mode": "fixed" }, "mappings": [ { "options": { "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "text", "index": 2 } }, "type": "value" }, { "options": { "match": "null", "result": { "index": 4, "text": "0" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 8, "w": 6, "x": 0, "y": 0 }, "id": 2, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^Total$/", "values": false }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 184, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "RED" } }, "fieldName": "StatusLight" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 7, "y": 0 }, "id": 88, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='16'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 104, "refId": "A" } ], "title": "P16", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 8, "y": 0 }, "id": 89, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='17'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P17", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 9, "y": 0 }, "id": 90, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='18'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P18", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 10, "y": 0 }, "id": 91, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='19'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P19", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 11, "y": 0 }, "id": 92, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='20'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P20", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 12, "y": 0 }, "id": 93, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='21'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P21", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 13, "y": 0 }, "id": 94, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='22'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P22", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 14, "y": 0 }, "id": 95, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='23'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P23", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 15, "y": 0 }, "id": 96, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='24'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P24", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 16, "y": 0 }, "id": 97, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='25'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P25", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 17, "y": 0 }, "id": 98, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='26'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P26", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 18, "y": 0 }, "id": 99, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='27'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P27", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 19, "y": 0 }, "id": 100, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='28'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P28", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 20, "y": 0 }, "id": 101, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='29'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P29", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 7, "y": 2 }, "id": 125, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "16 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 8, "y": 2 }, "id": 126, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "17 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 9, "y": 2 }, "id": 127, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "18 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 10, "y": 2 }, "id": 128, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "19 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 11, "y": 2 }, "id": 129, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "20 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 12, "y": 2 }, "id": 130, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "21 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 13, "y": 2 }, "id": 131, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "22 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 14, "y": 2 }, "id": 132, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "23 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 15, "y": 2 }, "id": 133, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "24 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 16, "y": 2 }, "id": 134, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "25 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 17, "y": 2 }, "id": 135, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "26 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 18, "y": 2 }, "id": 136, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "27 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 19, "y": 2 }, "id": 137, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "28 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 20, "y": 2 }, "id": 138, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "29 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 7, "y": 3 }, "id": 159, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "16 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 8, "y": 3 }, "id": 160, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "17 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 9, "y": 3 }, "id": 161, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "18 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 10, "y": 3 }, "id": 162, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "19 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 11, "y": 3 }, "id": 163, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "20 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 12, "y": 3 }, "id": 164, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "21 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 13, "y": 3 }, "id": 165, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "22 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 14, "y": 3 }, "id": 166, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "23 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 15, "y": 3 }, "id": 167, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "24" } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 16, "y": 3 }, "id": 168, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "25 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 17, "y": 3 }, "id": 169, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "26 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 18, "y": 3 }, "id": 170, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "27 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 19, "y": 3 }, "id": 171, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "28 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { "": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 20, "y": 3 }, "id": 172, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "29 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 7, "y": 4 }, "id": 6, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "16 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 8, "y": 4 }, "id": 10, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "17 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 9, "y": 4 }, "id": 11, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "18 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#fbfbfb", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 10, "y": 4 }, "id": 13, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "19 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 11, "y": 4 }, "id": 12, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "20 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#f6f6f6", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 12, "y": 4 }, "id": 36, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "21 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE ": { "color": "blue", "index": 3 }, "GREEN ": { "color": "green", "index": 1 }, "RED ": { "color": "red", "index": 0 }, "WHITE ": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 13, "y": 4 }, "id": 14, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "22 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE ": { "color": "blue", "index": 3 }, "GREEN ": { "color": "green", "index": 1 }, "RED ": { "color": "red", "index": 0 }, "WHITE ": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 14, "y": 4 }, "id": 15, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "23 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 15, "y": 4 }, "id": 16, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "24 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 16, "y": 4 }, "id": 17, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "25 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 17, "y": 4 }, "id": 18, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "26 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 18, "y": 4 }, "id": 19, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "27 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 19, "y": 4 }, "id": 20, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "28 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 20, "y": 4 }, "id": 21, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "29 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "#ffffff", "mode": "fixed" }, "mappings": [ { "options": { "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" }, { "options": { "match": "null", "result": { "index": 4, "text": "0" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 8, "w": 6, "x": 0, "y": 8 }, "id": 3, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^Total$/", "values": false }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 184, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "WHITE" } }, "fieldName": "StatusLight" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 7, "y": 8 }, "id": 199, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT230029" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 8, "y": 8 }, "id": 200, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "JW140041" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 9, "y": 8 }, "id": 201, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT230030" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 10, "y": 8 }, "id": 202, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR200017" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 11, "y": 8 }, "id": 203, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR200004" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 12, "y": 8 }, "id": 204, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR200022" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 13, "y": 8 }, "id": 205, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "DMINF002" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 14, "y": 8 }, "id": 206, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "DMINF008" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 15, "y": 8 }, "id": 207, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "DMINF008" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 16, "y": 8 }, "id": 208, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR320114" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 17, "y": 8 }, "id": 209, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MACHINE001" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 18, "y": 8 }, "id": 210, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR260002" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 19, "y": 8 }, "id": 211, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR260003" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 20, "y": 8 }, "id": 212, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR260004" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 15, "x": 7, "y": 9 }, "id": 102, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "editorMode": "code", "format": "table", "rawQuery": true, "rawSql": "insert into IoT.dbo.SelectedBuilding (Date,Building) VALUES (getDate(), '$building')", "refId": "A", "sql": { "columns": [ { "parameters": [], "type": "function" } ], "groupBy": [ { "property": { "type": "string" }, "type": "groupBy" } ], "limit": 50 } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 7, "y": 10 }, "id": 185, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT180074" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 8, "y": 10 }, "id": 186, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT180075" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 9, "y": 10 }, "id": 189, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "DMINF005" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 10, "y": 10 }, "id": 187, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT130077" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 11, "y": 10 }, "id": 188, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT130078" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 12, "y": 10 }, "id": 190, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT130079" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 13, "y": 10 }, "id": 191, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR200020" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 14, "y": 10 }, "id": 192, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT130081" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 15, "y": 10 }, "id": 193, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR200015" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 16, "y": 10 }, "id": 194, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT130083" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 17, "y": 10 }, "id": 195, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT130084" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 18, "y": 10 }, "id": 196, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT130085" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 19, "y": 10 }, "id": 197, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "MT130086" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 20, "y": 10 }, "id": 198, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^DateDif$/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR200024" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 21, "y": 10 }, "id": 181, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/.*/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 182, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BR260001" } }, "fieldName": "MchID" } ], "match": "any", "type": "include" } }, { "id": "filterFieldsByName", "options": { "include": { "names": [ "DateDif" ] } } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 7, "y": 11 }, "id": 9, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "15 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 8, "y": 11 }, "id": 22, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "14 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 9, "y": 11 }, "id": 23, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "13 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 10, "y": 11 }, "id": 24, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "12 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 11, "y": 11 }, "id": 25, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "11 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 12, "y": 11 }, "id": 26, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "10 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 13, "y": 11 }, "id": 27, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "first" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "09 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 14, "y": 11 }, "id": 28, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "08 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 15, "y": 11 }, "id": 29, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "07 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 16, "y": 11 }, "id": 30, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "06 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "#27002c", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 17, "y": 11 }, "id": 31, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "05 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE ": { "color": "blue", "index": 3 }, "GREEN ": { "color": "green", "index": 1 }, "RED ": { "color": "red", "index": 0 }, "WHITE ": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 18, "y": 11 }, "id": 32, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "04 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE ": { "color": "blue", "index": 3 }, "GREEN ": { "color": "green", "index": 1 }, "RED ": { "color": "red", "index": 0 }, "WHITE ": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 19, "y": 11 }, "id": 33, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "03 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0 ": { "color": "#27002c", "index": 4 }, "BLUE ": { "color": "blue", "index": 3 }, "GREEN ": { "color": "green", "index": 1 }, "RED ": { "color": "red", "index": 0 }, "WHITE ": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 20, "y": 11 }, "id": 34, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "02 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "color": "dark-purple", "index": 4 }, "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "transparent", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 4, "w": 1, "x": 21, "y": 11 }, "id": 173, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^StatusLight$/", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 179, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "01" } }, "fieldName": "MchNumber" } ], "match": "all", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 7, "y": 15 }, "id": 110, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "15 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 8, "y": 15 }, "id": 111, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "14 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 9, "y": 15 }, "id": 112, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "13 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 10, "y": 15 }, "id": 113, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "12 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 11, "y": 15 }, "id": 114, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "11 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 12, "y": 15 }, "id": 115, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "10 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 13, "y": 15 }, "id": 116, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "09 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 14, "y": 15 }, "id": 117, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "08 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 15, "y": 15 }, "id": 118, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "07 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 16, "y": 15 }, "id": 119, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "06 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 17, "y": 15 }, "id": 120, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "05 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 18, "y": 15 }, "id": 121, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "04 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 19, "y": 15 }, "id": 122, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "03 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 20, "y": 15 }, "id": 123, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "02 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 21, "y": 15 }, "id": 143, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchTon$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "01" } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "blue", "mode": "fixed" }, "mappings": [ { "options": { "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "#ffffff", "index": 2 } }, "type": "value" }, { "options": { "match": "null", "result": { "index": 4, "text": "0" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 0, "y": 16 }, "id": 4, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^Total$/", "values": false }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 184, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "BLUE" } }, "fieldName": "StatusLight" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 7, "y": 16 }, "id": 72, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='15'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": " P15", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 8, "y": 16 }, "id": 77, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='14'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P14", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 9, "y": 16 }, "id": 78, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='13'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P13", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 10, "y": 16 }, "id": 79, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='12'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P12", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 11, "y": 16 }, "id": 80, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='11'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P11", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 12, "y": 16 }, "id": 81, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='10'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P10", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 13, "y": 16 }, "id": 82, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='09'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P09", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 14, "y": 16 }, "id": 83, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='08'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P08", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 15, "y": 16 }, "id": 84, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='07'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P07", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "dashboard", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 16, "y": 16 }, "id": 85, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='06'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P06", "transformations": [], "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 17, "y": 16 }, "id": 86, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='05'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P05", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 18, "y": 16 }, "id": 87, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='04'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P04", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 19, "y": 16 }, "id": 75, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='03'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P03", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 20, "y": 16 }, "id": 76, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='02'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 6, "refId": "A" } ], "title": "P02", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "gridPos": { "h": 2, "w": 1, "x": 21, "y": 16 }, "id": 71, "options": { "buttons": [ { "datasource": "Microsoft SQL Server", "query": "{\n \"rawQuery\":true,\n \"rawSql\": \"exec InsertIntoShowMchRunTRX @MchLoc = '$building', @MchNumber ='01'\",\n \"format\": \"table\"\n}", "text": "Detail", "variant": "secondary" } ], "orientation": "horizontal" }, "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 88, "refId": "A" } ], "title": "P01", "type": "speakyourcode-button-panel" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 7, "y": 18 }, "id": 145, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "15 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 8, "y": 18 }, "id": 148, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "14 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 9, "y": 18 }, "id": 149, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "13 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 10, "y": 18 }, "id": 150, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "12 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 11, "y": 18 }, "id": 151, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "11 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 12, "y": 18 }, "id": 152, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "10 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 13, "y": 18 }, "id": 153, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "09 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 14, "y": 18 }, "id": 154, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "08 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 15, "y": 18 }, "id": 155, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "07 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 16, "y": 18 }, "id": 156, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "06 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 17, "y": 18 }, "id": 157, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "05 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 18, "y": 18 }, "id": 158, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "04 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 19, "y": 18 }, "id": 146, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "04 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 20, "y": 18 }, "id": 147, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "02 " } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "thresholds" }, "mappings": [ { "options": { " ": { "color": "transparent", "index": 0 } }, "type": "value" }, { "options": { "match": "null", "result": { "color": "transparent", "index": 1 } }, "type": "special" }, { "options": { "match": "empty", "result": { "color": "transparent", "index": 2 } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 1, "x": 21, "y": 18 }, "id": 144, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 18 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 177, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "01" } }, "fieldName": "MchNumber" } ], "match": "any", "type": "include" } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 7, "y": 19 }, "id": 104, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchNumber$/", "values": false }, "text": { "valueSize": 30 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "dataset": "IoT", "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "editorMode": "code", "format": "table", "rawQuery": true, "rawSql": "SELECT TOP(1) * FROM IoT.dbo.ShowMchRunTRX", "refId": "A", "sql": { "columns": [ { "parameters": [ { "name": "MchNumber", "type": "functionParameter" } ], "type": "function" } ], "groupBy": [ { "property": { "type": "string" }, "type": "groupBy" } ], "limit": 50 }, "table": "dbo.ShowMchRunTRX" } ], "title": "Machine Number", "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 5, "x": 10, "y": 19 }, "id": 140, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchID$/", "values": false }, "text": { "valueSize": 30 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 104, "refId": "A" } ], "title": "Machine ID", "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { " ": { "index": 0, "text": "-" } }, "type": "value" } ], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 7, "x": 15, "y": 19 }, "id": 141, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchStatus$/", "values": false }, "text": { "valueSize": 30 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 104, "refId": "A" } ], "title": "Machine Status", "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [], "noValue": "Please Click Machine Detail", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 15, "x": 7, "y": 21 }, "id": 139, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^MchDesc$/", "values": false }, "text": { "valueSize": 30 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 104, "refId": "A" } ], "title": "Machine Desc", "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "BLUE": { "color": "blue", "index": 3 }, "GREEN": { "color": "green", "index": 1 }, "RED": { "color": "red", "index": 0 }, "WHITE": { "color": "text", "index": 2 } }, "type": "value" }, { "options": { "match": "null", "result": { "index": 4, "text": "0" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 8, "w": 6, "x": 0, "y": 23 }, "id": 5, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "firstNotNull" ], "fields": "/^Total$/", "values": false }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 184, "refId": "A" } ], "transformations": [ { "id": "filterByValue", "options": { "filters": [ { "config": { "id": "equal", "options": { "value": "GREEN" } }, "fieldName": "StatusLight" } ], "match": "any", "type": "include" } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { " ": { "index": 0, "text": "-" } }, "type": "value" } ], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 3, "w": 8, "x": 7, "y": 23 }, "id": 106, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^ItemNo$/", "values": false }, "text": { "valueSize": 30 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 104, "refId": "A" } ], "title": "Current Item No", "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { " ": { "index": 0, "text": "-" } }, "type": "value" } ], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 3, "w": 7, "x": 15, "y": 23 }, "id": 107, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^ItemDesc$/", "values": false }, "text": { "valueSize": 30 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 104, "refId": "A" } ], "title": "Current Item Desc", "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { " ": { "index": 0, "text": "-" } }, "type": "value" } ], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 15, "x": 7, "y": 26 }, "id": 142, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^Message$/", "values": false }, "text": { "valueSize": 30 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 104, "refId": "A" } ], "title": "Message", "type": "stat" }, { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 8, "x": 7, "y": 28 }, "id": 174, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^TitleA$/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "editorMode": "code", "format": "table", "rawQuery": true, "rawSql": "Select top (1) * from IoT.dbo.GrafanaTitle", "refId": "A", "sql": { "columns": [ { "parameters": [], "type": "function" } ], "groupBy": [ { "property": { "type": "string" }, "type": "groupBy" } ], "limit": 50 } } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 1, "w": 7, "x": 15, "y": 28 }, "id": 175, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^TitleB$/", "values": false }, "text": { "valueSize": 16 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 174, "refId": "A" } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { " ": { "index": 0, "text": "-" } }, "type": "value" } ], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 8, "x": 7, "y": 29 }, "id": 108, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^Problem$/", "values": false }, "text": { "valueSize": 30 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 104, "refId": "A" } ], "type": "stat" }, { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "text", "mode": "fixed" }, "mappings": [ { "options": { " ": { "index": 0, "text": "-" } }, "type": "value" } ], "noValue": "-", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 7, "x": 15, "y": 29 }, "id": 109, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "/^ActionPlan$/", "values": false }, "text": { "valueSize": 30 }, "textMode": "value" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "datasource", "uid": "-- Dashboard --" }, "panelId": 104, "refId": "A" } ], "type": "stat" }, { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 5, "w": 22, "x": 0, "y": 31 }, "id": 180, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "none" }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "editorMode": "code", "format": "table", "rawQuery": true, "rawSql": "", "refId": "A", "sql": { "columns": [ { "parameters": [], "type": "function" } ], "groupBy": [ { "property": { "type": "string" }, "type": "groupBy" } ], "limit": 50 } } ], "transparent": true, "type": "stat" }, { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "cellOptions": { "type": "auto" }, "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 0, "y": 36 }, "id": 177, "options": { "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "editorMode": "code", "format": "table", "rawQuery": true, "rawSql": "EXEC SelectMchStatusTon @MchLoc = '$building'", "refId": "A", "sql": { "columns": [ { "parameters": [], "type": "function" } ], "groupBy": [ { "property": { "type": "string" }, "type": "groupBy" } ], "limit": 50 } } ], "title": "MachineStatus", "type": "table" }, { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "cellOptions": { "type": "auto" }, "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 7, "w": 5, "x": 6, "y": 36 }, "id": 179, "options": { "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [ { "desc": false, "displayName": "MchNumber" } ] }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "editorMode": "code", "format": "table", "rawQuery": true, "rawSql": "EXEC SelectStatusLight @MchLoc = '$building'", "refId": "A", "sql": { "columns": [ { "parameters": [], "type": "function" } ], "groupBy": [ { "property": { "type": "string" }, "type": "groupBy" } ], "limit": 50 } } ], "title": "StatusLight", "transformations": [ { "id": "groupBy", "options": { "fields": { "MchNumber": { "aggregations": [ "uniqueValues", "lastNotNull" ], "operation": "groupby" }, "StatusLight": { "aggregations": [ "first" ], "operation": "aggregate" } } } } ], "type": "table" }, { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "cellOptions": { "type": "auto" }, "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [] }, "gridPos": { "h": 7, "w": 4, "x": 11, "y": 36 }, "id": 182, "options": { "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [ { "desc": false, "displayName": "MchNumber" } ] }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "editorMode": "code", "format": "table", "rawQuery": true, "rawSql": "EXEC DateDiffCounterDate", "refId": "A", "sql": { "columns": [ { "parameters": [], "type": "function" } ], "groupBy": [ { "property": { "type": "string" }, "type": "groupBy" } ], "limit": 50 } } ], "title": "DateDiff", "transformations": [], "type": "table" }, { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "cellOptions": { "type": "auto" }, "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "StatusLight" }, "properties": [ { "id": "custom.width", "value": 110 } ] } ] }, "gridPos": { "h": 7, "w": 4, "x": 15, "y": 36 }, "id": 184, "options": { "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [] }, "pluginVersion": "9.4.3", "targets": [ { "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "editorMode": "code", "format": "table", "rawQuery": true, "rawSql": "EXEC StatusLightOverall @MchLoc = '$building'", "refId": "A", "sql": { "columns": [ { "parameters": [], "type": "function" } ], "groupBy": [ { "property": { "type": "string" }, "type": "groupBy" } ], "limit": 50 } } ], "title": "StatusLightOverall", "transformations": [], "type": "table" } ], "refresh": "5s", "revision": 1, "schemaVersion": 38, "style": "dark", "tags": [], "templating": { "list": [ { "current": { "selected": false, "text": "INJ Bld J ", "value": "INJ Bld J " }, "datasource": { "type": "mssql", "uid": "l7FS-wZgz" }, "definition": " select distinct MchLoc from IoT.dbo.MachineMST", "hide": 0, "includeAll": false, "label": "Building", "multi": false, "name": "building", "options": [], "query": " select distinct MchLoc from IoT.dbo.MachineMST", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 1, "type": "query" } ] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": {}, "timezone": "", "title": "Machine", "uid": "IxLellzgz", "version": 92, "weekStart": "" }
Editor is loading...