Influxdb Querys
MEAN Value
- SELECT MEAN("bytes") FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic'
Calculate
- SELECT MEAN("bytes") / 10000000000 FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic'
DERIVATIVE per Second
- SELECT DERIVATIVE("bytes,1s") FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic'