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...