querybuilder

plugin:
Object
xhrStatus:"complete"
request:Object
method:"POST"
url:"api/datasources/proxy/1/query"
params:Object
db:"telegraf"
epoch:"ms"
data:"q=SELECT%20last(%22s_status%22)%20FROM%20%22switch_status%22%20WHERE%20(%22building_name%22%20!%3D%20'%22Building%20-%20Parking%22')%20AND%20time%20%3E%3D%20now()%20-%203h%20GROUP%20BY%20time(1m)%2C%20%22building_name%22%20fill(previous)"
precision:"ms"
response:Object
results:Array[1]
0:Object
statement_id:0
series:Array[171]
0:Object
name:"switch_status"
tags:Object
building_name:""AUX Devices""
columns:Array[2]
0:"time"
1:"last"
values:Array[181]
0:Array[1558891800000,null]
1:Array[1558891860000,Up]
2:Array[1558891920000,Up]
3:Array[1558891980000,Up]
4:Array[1558892040000,Up]
5:Array[1558892100000,Up]
6:Array[1558892160000,Up]
7:Array[1558892220000,Up]
8:Array[1558892280000,Up]
9:Array[1558892340000,Up]
10:Array[1558892400000,Up]
11:Array[1558892460000,Up]
12:Array[1558892520000,Up]
13:Array[1558892580000,Up]
14:Array[1558892640000,Up]
15:Array[1558892700000,Up]
16:Array[1558892760000,Up]
17:Array[1558892820000,Up]
18:Array[1558892880000,Up]
19:Array[1558892940000,Up]
20:Array[1558893000000,Up]
21:Array[1558893060000,Up]
22:Array[1558893120000,Up]
23:Array[1558893180000,Up]
24:Array[1558893240000,Up]
25:Array[1558893300000,Up]
26:Array[1558893360000,Up]
27:Array[1558893420000,Up]
28:Array[1558893480000,Up]
29:Array[1558893540000,Up]
30:Array[1558893600000,Up]
31:Array[1558893660000,Up]
32:Array[1558893720000,Up]
33:Array[1558893780000,Up]
34:Array[1558893840000,Up]
35:Array[1558893900000,Up]
36:Array[1558893960000,Up]
37:Array[1558894020000,Up]
38:Array[1558894080000,Up]
39:Array[1558894140000,Up]
40:Array[1558894200000,Up]
41:Array[1558894260000,Up]
42:Array[1558894320000,Up]
43:Array[1558894380000,Up]
44:Array[1558894440000,Up]
45:Array[1558894500000,Up]
46:Array[1558894560000,Up]
47:Array[1558894620000,Up]
48:Array[1558894680000,Up]
49:Array[1558894740000,Up]
50:Array[1558894800000,Up]
51:Array[1558894860000,Up]
52:Array[1558894920000,Up]
53:Array[1558894980000,Up]
54:Array[1558895040000,Up]
55:Array[1558895100000,Up]
56:Array[1558895160000,Up]
57:Array[1558895220000,Up]
58:Array[1558895280000,Up]
59:Array[1558895340000,Up]
60:Array[1558895400000,Up]
61:Array[1558895460000,Up]
62:Array[1558895520000,Up]
63:Array[1558895580000,Up]
64:Array[1558895640000,Up]
65:Array[1558895700000,Up]
66:Array[1558895760000,Up]
67:Array[1558895820000,Up]
68:Array[1558895880000,Up]
69:Array[1558895940000,Up]
70:Array[1558896000000,Up]
71:Array[1558896060000,Up]
72:Array[1558896120000,Up]
73:Array[1558896180000,Up]
74:Array[1558896240000,Up]
75:Array[1558896300000,Up]
76:Array[1558896360000,Up]
77:Array[1558896420000,Up]
78:Array[1558896480000,Up]
79:Array[1558896540000,Up]
80:Array[1558896600000,Up]
81:Array[1558896660000,Up]
82:Array[1558896720000,Up]
83:Array[1558896780000,Up]
84:Array[1558896840000,Up]
85:Array[1558896900000,Up]
86:Array[1558896960000,Up]
87:Array[1558897020000,Up]
88:Array[1558897080000,Up]
89:Array[1558897140000,Up]
90:Array[1558897200000,Up]
91:Array[1558897260000,Up]
92:Array[1558897320000,Up]
93:Array[1558897380000,Up]
94:Array[1558897440000,Up]
95:Array[1558897500000,Up]
96:Array[1558897560000,Up]
97:Array[1558897620000,Up]
98:Array[1558897680000,Up]
99:Array[1558897740000,Up]
100:Array[1558897800000,Up]
101:Array[1558897860000,Up]
102:Array[1558897920000,Up]
103:Array[1558897980000,Up]
104:Array[1558898040000,Up]
105:Array[1558898100000,Up]
106:Array[1558898160000,Up]
107:Array[1558898220000,Up]
108:Array[1558898280000,Up]
109:Array[1558898340000,Up]
110:Array[1558898400000,Up]
111:Array[1558898460000,Up]
112:Array[1558898520000,Up]
113:Array[1558898580000,Up]
114:Array[1558898640000,Up]
115:Array[1558898700000,Up]
116:Array[1558898760000,Up]
117:Array[1558898820000,Up]
118:Array[1558898880000,Up]
119:Array[1558898940000,Up]
120:Array[1558899000000,Up]
121:Array[1558899060000,Up]
122:Array[1558899120000,Up]
123:Array[1558899180000,Up]
124:Array[1558899240000,Up]
125:Array[1558899300000,Up]
126:Array[1558899360000,Up]
127:Array[1558899420000,Up]
128:Array[1558899480000,Up]
129:Array[1558899540000,Up]
130:Array[1558899600000,Up]
131:Array[1558899660000,Up]
132:Array[1558899720000,Up]
133:Array[1558899780000,Up]
134:Array[1558899840000,Up]
135:Array[1558899900000,Up]
136:Array[1558899960000,Up]
137:Array[1558900020000,Up]
138:Array[1558900080000,Up]
139:Array[1558900140000,Up]
140:Array[1558900200000,Up]
141:Array[1558900260000,Up]
142:Array[1558900320000,Up]
143:Array[1558900380000,Up]
144:Array[1558900440000,Up]
145:Array[1558900500000,Up]
146:Array[1558900560000,Up]
147:Array[1558900620000,Up]
148:Array[1558900680000,Up]
149:Array[1558900740000,Up]
150:Array[1558900800000,Up]
151:Array[1558900860000,Up]
152:Array[1558900920000,Up]
153:Array[1558900980000,Up]
154:Array[1558901040000,Up]
155:Array[1558901100000,Up]
156:Array[1558901160000,Up]
157:Array[1558901220000,Up]
158:Array[1558901280000,Up]
159:Array[1558901340000,Up]
160:Array[1558901400000,Up]
161:Array[1558901460000,Up]
162:Array[1558901520000,Up]
163:Array[1558901580000,Up]
164:Array[1558901640000,Up]
165:Array[1558901700000,Up]
166:Array[1558901760000,Up]
167:Array[1558901820000,Up]
168:Array[1558901880000,Up]
169:Array[1558901940000,Up]
170:Array[1558902000000,Up]
171:Array[1558902060000,Up]
172:Array[1558902120000,Up]
173:Array[1558902180000,Up]
174:Array[1558902240000,Up]
175:Array[1558902300000,Up]
176:Array[1558902360000,Up]
177:Array[1558902420000,Up]
178:Array[1558902480000,Up]
179:Array[1558902540000,Up]
180:Array[1558902600000,Up]
1:Object
name:"switch_status"
tags:Object
building_name:""All Buildings""
columns:Array[2]
0:"time"
1:"last"
values:Array[181]
0:Array[1558891800000,Up]
1:Array[1558891860000,Warning]
2:Array[1558891920000,Warning]
3:Array[1558891980000,Warning]
4:Array[1558892040000,Warning]
5:Array[1558892100000,Warning]
6:Array[1558892160000,Warning]
7:Array[1558892220000,Warning]
8:Array[1558892280000,Warning]
9:Array[1558892340000,Warning]
10:Array[1558892400000,Warning]
11:Array[1558892460000,Warning]
12:Array[1558892520000,Warning]
13:Array[1558892580000,Warning]
14:Array[1558892640000,Warning]
15:Array[1558892700000,Warning]
16:Array[1558892760000,Warning]
17:Array[1558892820000,Warning]
18:Array[1558892880000,Warning]
19:Array[1558892940000,Warning]
20:Array[1558893000000,Warning]
21:Array[1558893060000,Warning]
22:Array[1558893120000,Warning]
23:Array[1558893180000,Warning]
24:Array[1558893240000,Warning]
25:Array[1558893300000,Warning]
26:Array[1558893360000,Warning]
27:Array[1558893420000,Warning]
28:Array[1558893480000,Warning]
29:Array[1558893540000,Warning]
30:Array[1558893600000,Warning]
31:Array[1558893660000,Warning]
32:Array[1558893720000,Warning]
33:Array[1558893780000,Warning]
34:Array[1558893840000,Warning]
35:Array[1558893900000,Warning]
36:Array[1558893960000,Warning]
37:Array[1558894020000,Warning]
38:Array[1558894080000,Warning]
39:Array[1558894140000,Warning]
40:Array[1558894200000,Warning]
41:Array[1558894260000,Warning]
42:Array[1558894320000,Warning]
43:Array[1558894380000,Warning]
44:Array[1558894440000,Warning]
45:Array[1558894500000,Warning]
46:Array[1558894560000,Warning]
47:Array[1558894620000,Warning]
48:Array[1558894680000,Warning]
49:Array[1558894740000,Warning]
50:Array[1558894800000,Warning]
51:Array[1558894860000,Warning]
52:Array[1558894920000,Warning]
53:Array[1558894980000,Warning]
54:Array[1558895040000,Warning]
55:Array[1558895100000,Warning]
56:Array[1558895160000,Warning]
57:Array[1558895220000,Warning]
58:Array[1558895280000,Warning]
59:Array[1558895340000,Warning]
60:Array[1558895400000,Warning]
61:Array[1558895460000,Warning]
62:Array[1558895520000,Warning]
63:Array[1558895580000,Warning]
64:Array[1558895640000,Warning]
65:Array[1558895700000,Warning]
66:Array[1558895760000,Warning]
67:Array[1558895820000,Warning]
68:Array[1558895880000,Warning]
69:Array[1558895940000,Warning]
70:Array[1558896000000,Warning]
71:Array[1558896060000,Warning]
72:Array[1558896120000,Warning]
73:Array[1558896180000,Warning]
74:Array[1558896240000,Warning]
75:Array[1558896300000,Warning]
76:Array[1558896360000,Warning]
77:Array[1558896420000,Warning]
78:Array[1558896480000,Warning]
79:Array[1558896540000,Warning]
80:Array[1558896600000,Warning]
81:Array[1558896660000,Warning]
82:Array[1558896720000,Warning]
83:Array[1558896780000,Warning]
84:Array[1558896840000,Warning]
85:Array[1558896900000,Warning]
86:Array[1558896960000,Warning]
87:Array[1558897020000,Warning]
88:Array[1558897080000,Warning]
89:Array[1558897140000,Warning]
90:Array[1558897200000,Warning]
91:Array[1558897260000,Warning]
92:Array[1558897320000,Warning]
93:Array[1558897380000,Warning]
94:Array[1558897440000,Warning]
95:Array[1558897500000,Warning]
96:Array[1558897560000,Warning]
97:Array[1558897620000,Warning]
98:Array[1558897680000,Warning]
99:Array[1558897740000,Warning]
100:Array[1558897800000,Warning]
101:Array[1558897860000,Warning]
102:Array[1558897920000,Warning]
103:Array[1558897980000,Warning]
104:Array[1558898040000,Warning]
105:Array[1558898100000,Warning]
106:Array[1558898160000,Warning]
107:Array[1558898220000,Warning]
108:Array[1558898280000,Warning]
109:Array[1558898340000,Warning]
110:Array[1558898400000,Warning]
111:Array[1558898460000,Warning]
112:Array[1558898520000,Warning]
113:Array[1558898580000,Warning]
114:Array[1558898640000,Warning]
115:Array[1558898700000,Warning]
116:Array[1558898760000,Warning]
117:Array[1558898820000,Warning]
118:Array[1558898880000,Warning]
119:Array[1558898940000,Warning]
120:Array[1558899000000,Warning]
121:Array[1558899060000,Warning]
122:Array[1558899120000,Warning]
123:Array[1558899180000,Warning]
124:Array[1558899240000,Warning]
125:Array[1558899300000,Warning]
126:Array[1558899360000,Warning]
127:Array[1558899420000,Warning]
128:Array[1558899480000,Warning]
129:Array[1558899540000,Warning]
130:Array[1558899600000,Warning]
131:Array[1558899660000,Warning]
132:Array[1558899720000,Warning]
133:Array[1558899780000,Warning]
134:Array[1558899840000,Warning]
135:Array[1558899900000,Warning]
136:Array[1558899960000,Warning]
137:Array[1558900020000,Warning]
138:Array[1558900080000,Warning]
139:Array[1558900140000,Warning]
140:Array[1558900200000,Warning]
141:Array[1558900260000,Warning]
142:Array[1558900320000,Warning]
143:Array[1558900380000,Warning]
144:Array[1558900440000,Warning]
145:Array[1558900500000,Warning]
146:Array[1558900560000,Warning]
147:Array[1558900620000,Warning]
148:Array[1558900680000,Warning]
149:Array[1558900740000,Warning]
150:Array[1558900800000,Warning]
151:Array[1558900860000,Warning]
152:Array[1558900920000,Warning]
153:Array[1558900980000,Warning]
154:Array[1558901040000,Warning]
155:Array[1558901100000,Warning]
156:Array[1558901160000,Warning]
157:Array[1558901220000,Warning]
158:Array[1558901280000,Warning]
159:Array[1558901340000,Warning]
160:Array[1558901400000,Warning]
161:Array[1558901460000,Warning]
162:Array[1558901520000,Warning]
163:Array[1558901580000,Warning]
164:Array[1558901640000,Warning]
165:Array[1558901700000,Warning]
166:Array[1558901760000,Warning]
167:Array[1558901820000,Warning]
168:Array[1558901880000,Warning]
169:Array[1558901940000,Warning]
170:Array[1558902000000,Warning]
171:Array[1558902060000,Warning]
172:Array[1558902120000,Warning]
173:Array[1558902180000,Warning]
174:Array[1558902240000,Warning]
175:Array[1558902300000,Warning]
176:Array[1558902360000,Warning]
177:Array[1558902420000,Warning]
178:Array[1558902480000,Warning]
179:Array[1558902540000,Warning]
180:Array[1558902600000,Warning]
2:Object
3:Object
4:Object
5:Object
6:Object
7:Object
8:Object
9:Object
10:Object
11:Object
12:Object
13:Object
14:Object
15:Object
16:Object
17:Object
18:Object
19:Object
20:Object
21:Object
22:Object
23:Object
24:Object
25:Object
26:Object
27:Object
28:Object
29:Object
30:Object
31:Object
32:Object
33:Object
34:Object
35:Object
36:Object
37:Object
38:Object
39:Object
40:Object
41:Object
42:Object
43:Object
44:Object
45:Object
46:Object
47:Object
48:Object
49:Object
50:Object
51:Object
52:Object
53:Object
54:Object
55:Object
56:Object
57:Object
58:Object
59:Object
60:Object
61:Object
62:Object
63:Object
64:Object
65:Object
66:Object
67:Object
68:Object
69:Object
70:Object
71:Object
72:Object
73:Object
74:Object
75:Object
76:Object
77:Object
78:Object
79:Object
80:Object
81:Object
82:Object
83:Object
84:Object
85:Object
86:Object
87:Object
88:Object
89:Object
90:Object
91:Object
92:Object
93:Object
94:Object
95:Object
96:Object
97:Object
98:Object
99:Object
100:Object
101:Object
102:Object
103:Object
104:Object
105:Object
106:Object
107:Object
108:Object
109:Object
110:Object
111:Object
112:Object
113:Object
114:Object
115:Object
116:Object
117:Object
118:Object
119:Object
120:Object
121:Object
122:Object
123:Object
124:Object
125:Object
126:Object
127:Object
128:Object
129:Object
130:Object
131:Object
132:Object
133:Object
134:Object
135:Object
136:Object
137:Object
138:Object
139:Object
140:Object
141:Object
142:Object
143:Object
144:Object
145:Object
146:Object
147:Object
148:Object
149:Object
150:Object
151:Object
152:Object
153:Object
154:Object
155:Object
156:Object
157:Object
158:Object
159:Object
160:Object
161:Object
162:Object
163:Object
164:Object
165:Object
166:Object
167:Object
168:Object
169:Object
170:Object

working plugin:
Object
xhrStatus:"complete"
request:Object
method:"POST"
url:"api/datasources/proxy/1/query"
params:Object
db:"telegraf"
epoch:"ms"
data:"q=SELECT%20non_negative_derivative(mean(bytes_recv)%2C1s)*8%20as%20%22in%22%20%20FROM%20%22net%22%20WHERE%20host%20%3D~%20%2Facnssympa%2F%20AND%20interface%20%3D~%20%2F(ens%7Ceno%7Cvlan%7Ceth%7Cbond).*%2F%20AND%20time%20%3E%3D%20now()%20-%2030m%20GROUP%20BY%20time(30s)%2C%20*%20fill(none)%3BSELECT%20non_negative_derivative(mean(bytes_sent)%2C1s)*8%20as%20%22out%22%20FROM%20%22net%22%20WHERE%20host%20%3D~%20%2Facnssympa%2F%20AND%20interface%20%3D~%20%2F(ens%7Ceno%7Cvlan%7Ceth%7Cbond).*%2F%20AND%20time%20%3E%3D%20now()%20-%2030m%20GROUP%20BY%20time(30s)%2C%20*%20fill(none)"
precision:"ms"
response:Object
results:Array[2]
0:Object
statement_id:0
series:Array[2]
0:Object
name:"net"
tags:Object
host:"acnssympa"
interface:"eno16780032"
columns:Array[2]
0:"time"
1:"in"
values:Array[61]
0:Array[1558900950000,6726.044444465637]
1:Array[1558900980000,10156.977777735392]
2:Array[1558901010000,8151.377777798971]
3:Array[1558901040000,10980.17777779897]
4:Array[1558901070000,9793.42222220103]
5:Array[1558901100000,7487.555555534363]
6:Array[1558901130000,8128.355555597941]
7:Array[1558901160000,11623.82222220103]
8:Array[1558901190000,11360.8]
9:Array[1558901220000,9931.466666666667]
10:Array[1558901250000,8654.844444465638]
11:Array[1558901280000,11609.511111068725]
12:Array[1558901310000,9606.4]
13:Array[1558901340000,10648.977777798971]
14:Array[1558901370000,10878.133333333333]
15:Array[1558901400000,7304.444444465637]
16:Array[1558901430000,8281.066666666668]
17:Array[1558901460000,8359.555555534364]
18:Array[1558901490000,7478.22222220103]
19:Array[1558901520000,12423.733333333334]
20:Array[1558901550000,11598.311111132303]
21:Array[1558901580000,11764.266666666666]
22:Array[1558901610000,10943.466666666667]
23:Array[1558901640000,13499.911111132304]
24:Array[1558901670000,12297.42222220103]
25:Array[1558901700000,10622.666666666666]
26:Array[1558901730000,9313.511111132304]
27:Array[1558901760000,9428.8]
28:Array[1558901790000,10031.555555534364]
29:Array[1558901820000,9152.711111132305]
30:Array[1558901850000,8915.2]
31:Array[1558901880000,10321.866666666667]
32:Array[1558901910000,10959.82222220103]
33:Array[1558901940000,17098.133333333335]
34:Array[1558901970000,20750.311111132305]
35:Array[1558902000000,12440.8]
36:Array[1558902030000,16295.644444402058]
37:Array[1558902060000,9365.422222264608]
38:Array[1558902090000,10627.111111068725]
39:Array[1558902120000,10111.466666666667]
40:Array[1558902150000,12096.711111132305]
41:Array[1558902180000,11516.8]
42:Array[1558902210000,11863.911111132304]
43:Array[1558902240000,11508.977777735392]
44:Array[1558902270000,11378.844444465638]
45:Array[1558902300000,7949.77777779897]
46:Array[1558902330000,13172.533333333333]
47:Array[1558902360000,7730.755555534362]
48:Array[1558902390000,8541.6]
49:Array[1558902420000,7937.422222201029]
50:Array[1558902450000,23064.17777779897]
51:Array[1558902480000,11026.844444465638]
52:Array[1558902510000,8850.22222220103]
53:Array[1558902540000,10255.2]
54:Array[1558902570000,9989.511111132304]
55:Array[1558902600000,8431.82222220103]
56:Array[1558902630000,8910.311111132303]
57:Array[1558902660000,8793.42222220103]
58:Array[1558902690000,49578.844444465634]
59:Array[1558902720000,11312.8]
60:Array[1558902750000,8255.82222220103]
1:Object
name:"net"
tags:Object
columns:Array[2]
values:Array[61]
1:Object