Hello, I’m trying to figure out how to convert a rather simple influxql query to influxdb 2 but I just can’t find the correct way. This is the query:
SELECT NON_NEGATIVE_DERIVATIVE(MEAN(transmit), 10s) as transmit, NON_NEGATIVE_DERIVATIVE(MEAN(receive), 10s) as receive
WHERE (host = ‘somethost’)
AND time >= ‘3600s’
GROUP BY time(600s), host fill(none)
Can someone help me with this please?