1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
| {
"aliasColors": {
"consumption": "#BF1B00",
"energy": "dark-yellow",
"gas": "#BF1B00",
"m3": "#BF1B00",
"power": "dark-yellow"
},
"dashLength": 10,
"datasource": "energy",
"decimals": 3,
"fieldConfig": {
"defaults": {
"custom": {},
"links": []
},
"overrides": []
},
"fill": 10,
"fillGradient": 10,
"gridPos": {
"h": 11,
"w": 11,
"x": 12,
"y": 49
},
"height": "400",
"id": 94,
"legend": {
"alignAsTable": true,
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"paceLength": 10,
"pluginVersion": "7.3.1",
"pointradius": 5,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"steppedLine": true,
"targets": [
{
"alias": "power",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT difference(last(\"gas\")) * 9.769 * 12 FROM \"gas\" WHERE $timeFilter GROUP BY time(5m) fill(previous)",
"rawQuery": true,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeRegions": [],
"title": " ${__from:date:YYYY-MM-DD} - gas",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "short",
"label": "kW",
"logBase": 1,
"max": "25",
"min": "0",
"show": true,
"$$hashKey": "object:161"
},
{
"format": "short",
"label": "kWh",
"logBase": 1,
"max": "2",
"min": "0",
"show": false,
"$$hashKey": "object:162"
}
],
"yaxis": {
"align": false,
"alignLevel": null
},
"bars": false,
"dashes": false,
"hiddenSeries": false,
"percentage": false,
"points": false,
"stack": false,
"timeFrom": null,
"timeShift": null
} |