{
"__inputs": [
{
"name": "VAR_DEVICE",
"type": "constant",
"label": "Device",
"value": "-",
"description": ""
},
{
"name": "VAR_ENERGY",
"type": "constant",
"label": "Energy",
"value": "-",
"description": ""
},
{
"name": "VAR_AIR",
"type": "constant",
"label": "Air",
"value": "-",
"description": ""
},
{
"name": "VAR_WATER",
"type": "constant",
"label": "Water",
"value": "-",
"description": ""
},
{
"name": "VAR_NITROGEN",
"type": "constant",
"label": "Nitrogen",
"value": "-",
"description": ""
},
{
"name": "VAR_WORKSTATION",
"type": "constant",
"label": "Workstation",
"value": "-",
"description": ""
},
{
"name": "VAR_PRODUCTIONTEAM",
"type": "constant",
"label": "Production Team",
"value": "-",
"description": ""
},
{
"name": "VAR_FLOOR",
"type": "constant",
"label": "Floor",
"value": "-",
"description": ""
},
{
"name": "VAR_BUILDING",
"type": "constant",
"label": "Building",
"value": "-",
"description": ""
},
{
"name": "VAR_COUNTRY",
"type": "constant",
"label": "Country",
"value": "-",
"description": ""
},
{
"name": "VAR_COMPANYLOGO",
"type": "constant",
"label": "Company Logo",
"value": "https://upload.wikimedia.org/wikipedia/commons/thumb/5/5b/Phoenix_Contact_Logo.svg/744px-Phoenix_Contact_Logo.svg.png",
"description": ""
},
{
"name": "VAR_ENERGYCOSTS",
"type": "constant",
"label": "€ / kWh",
"value": "0.32",
"description": ""
},
{
"name": "VAR_WATERCOSTS",
"type": "constant",
"label": "€ / l",
"value": "0.02",
"description": ""
},
{
"name": "VAR_AIRCOSTS",
"type": "constant",
"label": "€ / l (air)",
"value": "0.02",
"description": ""
},
{
"name": "VAR_NITROGENCOSTS",
"type": "constant",
"label": "Nitrogen Costs",
"value": "0.15",
"description": ""
}
],
"__requires": [
{
"type": "panel",
"id": "blackmirror1-singlestat-math-panel",
"name": "Singlestat Math",
"version": "1.1.8"
},
{
"type": "panel",
"id": "dashlist",
"name": "Dashboard list",
"version": ""
},
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "7.5.16"
},
{
"type": "panel",
"id": "piechart",
"name": "Pie chart v2",
"version": ""
},
{
"type": "panel",
"id": "text",
"name": "Text",
"version": ""
}
],
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
"description": "",
"editable": true,
"gnetId": null,
"graphTooltip": 0,
"id": null,
"iteration": 1661757013304,
"links": [],
"panels": [
{
"collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 0
},
"id": 6,
"panels": [],
"title": "Header",
"type": "row"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 14,
"x": 0,
"y": 1
},
"id": 2,
"options": {
"content": "# $ProductionTeam\nThe consumptions shown here are for the workstation __${ProductionTeam}__. \n${Country} > ${Building} > ${Floor} > __${ProductionTeam}__\n",
"mode": "markdown"
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"transparent": true,
"type": "text"
},
{
"cacheTimeout": null,
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 20,
"y": 1
},
"id": 4,
"interval": null,
"links": [],
"maxDataPoints": 3,
"options": {
"content": "",
"mode": "markdown"
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "/^$Energy$/",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"transparent": true,
"type": "text"
},
{
"collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 4
},
"id": 8,
"panels": [],
"title": "Navigation",
"type": "row"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 9,
"w": 24,
"x": 0,
"y": 5
},
"id": 36,
"options": {
"folderId": null,
"maxItems": 10,
"query": "",
"showHeadings": false,
"showRecentlyViewed": false,
"showSearch": true,
"showStarred": false,
"tags": []
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"type": "dashlist"
},
{
"collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 14
},
"id": 54,
"panels": [],
"title": "Overview",
"type": "row"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 1,
"w": 12,
"x": 0,
"y": 15
},
"id": 56,
"options": {
"content": "",
"mode": "markdown"
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "$ProductionTeam",
"type": "text"
},
{
"cacheTimeout": null,
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"mappings": [],
"max": 1,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 6,
"x": 12,
"y": 15
},
"id": 72,
"interval": null,
"links": [],
"maxDataPoints": null,
"options": {
"displayLabels": [
"value"
],
"legend": {
"displayMode": "table",
"placement": "bottom",
"values": [
"value",
"percent"
]
},
"pieType": "pie",
"reduceOptions": {
"calcs": [
"sum"
],
"fields": "",
"values": false
},
"text": {}
},
"pluginVersion": "7.5.16",
"targets": [
{
"alias": "Assembly Energy",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"value\") FROM \"auto~Germany_G1_GF_PT01_Assembly_Energy\" WHERE (\"uuid\" = '$Device') AND $timeFilter GROUP BY time(1h) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"title": "Energy Distribution",
"type": "piechart"
},
{
"cacheTimeout": null,
"datasource": null,
"description": "The consumptions shown here are for the workstation __${Workstation}__. \n${Country} > ${Building} > ${Floor} > ${ProductionTeam} > __${Workstation}__",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 6,
"x": 18,
"y": 15
},
"id": 73,
"interval": null,
"links": [],
"maxDataPoints": null,
"options": {
"displayLabels": [
"value"
],
"legend": {
"displayMode": "table",
"placement": "bottom",
"values": [
"percent",
"value"
]
},
"pieType": "pie",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {}
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"*1000"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"title": "Water",
"type": "piechart"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 0,
"y": 16
},
"id": 22,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1419",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1420",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "Assembly Energy",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"value\") FROM \"auto~Germany_G1_GF_PT01_Assembly_Energy\" WHERE (\"uuid\" = '$Device') AND $timeFilter GROUP BY time(1h) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Energy",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1422",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "The consumptions shown here are for the workstation __${Workstation}__. \n${Country} > ${Building} > ${Floor} > ${ProductionTeam} > __${Workstation}__",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "litre",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 3,
"y": 16
},
"id": 32,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1503",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1504",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Water",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"*1000"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Water",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1506",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "Nm3",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 6,
"y": 16
},
"id": 42,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1584",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1585",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Nitrogen",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"/1447"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Nitrogen",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1587",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "Nm3",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 9,
"y": 16
},
"id": 50,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1665",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1666",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "Workplace Air",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Air",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1668",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 1,
"w": 12,
"x": 0,
"y": 19
},
"id": 57,
"options": {
"content": "",
"mode": "markdown"
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "{Rename me}",
"type": "text"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 0,
"y": 20
},
"id": 60,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1419",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1420",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "Assembly Energy",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Energy",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1422",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "The consumptions shown here are for the workstation __${Workstation}__. \n${Country} > ${Building} > ${Floor} > ${ProductionTeam} > __${Workstation}__",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "litre",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 3,
"y": 20
},
"id": 63,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1503",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1504",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Water",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"*1000"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Water",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1506",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "Nm3",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 6,
"y": 20
},
"id": 66,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1584",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1585",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Nitrogen",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"/1447"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Nitrogen",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1587",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "Nm3",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 9,
"y": 20
},
"id": 69,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1665",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1666",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Air",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1668",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 1,
"w": 12,
"x": 0,
"y": 23
},
"id": 59,
"options": {
"content": "",
"mode": "markdown"
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "{Rename me}",
"type": "text"
},
{
"cacheTimeout": null,
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 6,
"x": 12,
"y": 23
},
"id": 74,
"interval": null,
"links": [],
"maxDataPoints": null,
"options": {
"displayLabels": [],
"legend": {
"displayMode": "table",
"placement": "bottom",
"values": [
"percent",
"value"
]
},
"pieType": "pie",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {}
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"/1447"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"title": "Nitrogen",
"type": "piechart"
},
{
"cacheTimeout": null,
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"mappings": [],
"max": 3,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "Nm3"
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 6,
"x": 18,
"y": 23
},
"id": 75,
"interval": null,
"links": [],
"maxDataPoints": null,
"options": {
"displayLabels": [
"value"
],
"legend": {
"displayMode": "table",
"placement": "bottom",
"values": [
"percent",
"value"
]
},
"pieType": "pie",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {}
},
"pluginVersion": "7.5.16",
"targets": [
{
"alias": "Workplace Air",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"title": "Air",
"type": "piechart"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 0,
"y": 24
},
"id": 61,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1419",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1420",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "Soldering Energy",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Energy",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1422",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "The consumptions shown here are for the workstation __${Workstation}__. \n${Country} > ${Building} > ${Floor} > ${ProductionTeam} > __${Workstation}__",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "litre",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 3,
"y": 24
},
"id": 64,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1503",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1504",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Water",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"*1000"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Water",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1506",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "Nm3",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 6,
"y": 24
},
"id": 67,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1584",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1585",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Nitrogen",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"/1447"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Nitrogen",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1587",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "Nm3",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 9,
"y": 24
},
"id": 70,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1665",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1666",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Air",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1668",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 1,
"w": 12,
"x": 0,
"y": 27
},
"id": 58,
"options": {
"content": "",
"mode": "markdown"
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "{Rename me}",
"type": "text"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 0,
"y": 28
},
"id": 62,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1419",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1420",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "Workplace Energy",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Energy",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1422",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "The consumptions shown here are for the workstation __${Workstation}__. \n${Country} > ${Building} > ${Floor} > ${ProductionTeam} > __${Workstation}__",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "litre",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 3,
"y": 28
},
"id": 65,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1503",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1504",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"*1000"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Water",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1506",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "Nm3",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 6,
"y": 28
},
"id": 68,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1584",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1585",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "Nitrogen",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"/1447"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Nitrogen",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1587",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "Nm3",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 3,
"x": 9,
"y": 28
},
"id": 71,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1665",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1666",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "Workplace Air",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeShift": null,
"title": "Air",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1668",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 31
},
"id": 77,
"panels": [],
"title": "Costs",
"type": "row"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 32
},
"id": 78,
"options": {
"content": "",
"mode": "markdown"
},
"pluginVersion": "7.5.16",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "$ProductionTeam",
"type": "text"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "currencyEUR",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 6,
"x": 0,
"y": 33
},
"id": 24,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1925",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1926",
"name": "range to text",
"value": 2
}
],
"math": "Workplace Energy+Soldering Energy+Assembly Energy",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "Assembly Energy",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"*$EnergyCosts"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"title": "Energy Costs",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "80%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1928",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "currencyEUR",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 6,
"x": 6,
"y": 33
},
"id": 34,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1925",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1926",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "Water",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
"*$WaterCosts"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"title": "Water Costs",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "50%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1928",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "currencyEUR",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 6,
"x": 12,
"y": 33
},
"id": 44,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1925",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1926",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"/1447*$NitrogenCosts"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"title": "Nitrogen Costs",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "80%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1928",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"circleBackground": false,
"colorBackground": false,
"colorValue": false,
"datasource": null,
"decimals": 2,
"defaultColor": "rgb(117, 117, 117)",
"description": "",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"format": "currencyEUR",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 6,
"x": 18,
"y": 33
},
"id": 52,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"$$hashKey": "object:1925",
"name": "value to text",
"value": 1
},
{
"$$hashKey": "object:1926",
"name": "range to text",
"value": 2
}
],
"math": "",
"maxDataPoints": null,
"nullPointMode": "connected",
"nullText": null,
"pluginVersion": "7.5.16",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sortOrder": "asc",
"sortOrderOptions": [
{
"text": "Ascending",
"value": "asc"
},
{
"text": "Descending",
"value": "desc"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false
},
"tableColumn": "",
"targets": [
{
"alias": "",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "-",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
"*$AirCosts"
],
"type": "math"
}
]
],
"tags": [
{
"key": "uuid",
"operator": "=",
"value": "$Device"
}
]
}
],
"thresholds": [],
"title": "Air Costs",
"tooltip": {
"show": false
},
"type": "blackmirror1-singlestat-math-panel",
"valueFontSize": "80%",
"valueMappingColorBackground": "#767171",
"valueMaps": [
{
"$$hashKey": "object:1928",
"op": "=",
"text": "No data",
"value": "null"
}
],
"valueName": "total"
}
],
"schemaVersion": 27,
"style": "dark",
"tags": [],
"templating": {
"list": [
{
"description": null,
"error": null,
"hide": 2,
"label": "Device",
"name": "Device",
"query": "${VAR_DEVICE}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_DEVICE}",
"text": "${VAR_DEVICE}",
"selected": false
},
"options": [
{
"value": "${VAR_DEVICE}",
"text": "${VAR_DEVICE}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Energy",
"name": "Energy",
"query": "${VAR_ENERGY}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_ENERGY}",
"text": "${VAR_ENERGY}",
"selected": false
},
"options": [
{
"value": "${VAR_ENERGY}",
"text": "${VAR_ENERGY}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Air",
"name": "Air",
"query": "${VAR_AIR}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_AIR}",
"text": "${VAR_AIR}",
"selected": false
},
"options": [
{
"value": "${VAR_AIR}",
"text": "${VAR_AIR}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Water",
"name": "Water",
"query": "${VAR_WATER}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_WATER}",
"text": "${VAR_WATER}",
"selected": false
},
"options": [
{
"value": "${VAR_WATER}",
"text": "${VAR_WATER}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Nitrogen",
"name": "Nitrogen",
"query": "${VAR_NITROGEN}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_NITROGEN}",
"text": "${VAR_NITROGEN}",
"selected": false
},
"options": [
{
"value": "${VAR_NITROGEN}",
"text": "${VAR_NITROGEN}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Workstation",
"name": "Workstation",
"query": "${VAR_WORKSTATION}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_WORKSTATION}",
"text": "${VAR_WORKSTATION}",
"selected": false
},
"options": [
{
"value": "${VAR_WORKSTATION}",
"text": "${VAR_WORKSTATION}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Production Team",
"name": "ProductionTeam",
"query": "${VAR_PRODUCTIONTEAM}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_PRODUCTIONTEAM}",
"text": "${VAR_PRODUCTIONTEAM}",
"selected": false
},
"options": [
{
"value": "${VAR_PRODUCTIONTEAM}",
"text": "${VAR_PRODUCTIONTEAM}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Floor",
"name": "Floor",
"query": "${VAR_FLOOR}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_FLOOR}",
"text": "${VAR_FLOOR}",
"selected": false
},
"options": [
{
"value": "${VAR_FLOOR}",
"text": "${VAR_FLOOR}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Building",
"name": "Building",
"query": "${VAR_BUILDING}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_BUILDING}",
"text": "${VAR_BUILDING}",
"selected": false
},
"options": [
{
"value": "${VAR_BUILDING}",
"text": "${VAR_BUILDING}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Country",
"name": "Country",
"query": "${VAR_COUNTRY}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_COUNTRY}",
"text": "${VAR_COUNTRY}",
"selected": false
},
"options": [
{
"value": "${VAR_COUNTRY}",
"text": "${VAR_COUNTRY}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Company Logo",
"name": "CompanyLogo",
"query": "${VAR_COMPANYLOGO}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_COMPANYLOGO}",
"text": "${VAR_COMPANYLOGO}",
"selected": false
},
"options": [
{
"value": "${VAR_COMPANYLOGO}",
"text": "${VAR_COMPANYLOGO}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "€ / kWh",
"name": "EnergyCosts",
"query": "${VAR_ENERGYCOSTS}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_ENERGYCOSTS}",
"text": "${VAR_ENERGYCOSTS}",
"selected": false
},
"options": [
{
"value": "${VAR_ENERGYCOSTS}",
"text": "${VAR_ENERGYCOSTS}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "€ / l",
"name": "WaterCosts",
"query": "${VAR_WATERCOSTS}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_WATERCOSTS}",
"text": "${VAR_WATERCOSTS}",
"selected": false
},
"options": [
{
"value": "${VAR_WATERCOSTS}",
"text": "${VAR_WATERCOSTS}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "€ / l (air)",
"name": "AirCosts",
"query": "${VAR_AIRCOSTS}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_AIRCOSTS}",
"text": "${VAR_AIRCOSTS}",
"selected": false
},
"options": [
{
"value": "${VAR_AIRCOSTS}",
"text": "${VAR_AIRCOSTS}",
"selected": false
}
]
},
{
"description": null,
"error": null,
"hide": 2,
"label": "Nitrogen Costs",
"name": "NitrogenCosts",
"query": "${VAR_NITROGENCOSTS}",
"skipUrlSync": false,
"type": "constant",
"current": {
"value": "${VAR_NITROGENCOSTS}",
"text": "${VAR_NITROGENCOSTS}",
"selected": false
},
"options": [
{
"value": "${VAR_NITROGENCOSTS}",
"text": "${VAR_NITROGENCOSTS}",
"selected": false
}
]
}
]
},
"time": {
"from": "now-30m",
"to": "now"
},
"timepicker": {},
"timezone": "",
"title": "Template Production Team",
"uid": "FWcwgTW4k",
"version": 7
}
