InfluxQL:
SELECT non_negative_derivative(mean("rx_bytes"), 1s) *8 from "usw_ports" WHERE ("device_name" = 'Waschraum' AND "port_idx" = '1') AND time >= now() - 1m GROUP by time(50ms)
returns
name: usw_ports
time non_negative_derivative
---- -----------------------
1596484246350000000 2630569.3178036604
If I run the same query with the python library nothing is returned.
Python:
r = c.query('SELECT non_negative_derivative(mean("rx_bytes"), 1s) *8 from "usw_ports" WHERE ("device_name" = "'"Waschraum"'" AND "port_idx" = "'"1"'") AND time >= now() - 1m GROUP by time(50ms);')
print(r)
ResultSet({})
