Hi, if this not appropriate to post here just delete it, thanks.
I was reading the influxDB documentation. I knew influxDB not support to do multiple series mathematics.
But if I want to count data from same measurement same field but different tag keys ?
- There are 3 hosts: sever1, server2, server3. Each of them have 3 device: (sda, sdb, sdc)
- database: telegraf
- Measurement : " disk "
- Field : " tps "
- Tag keys = host, device
For exmaple, I want get seriesA which is sum(last(tps)) from device ‘sdb’ but only count server1 + server2.
SELECT sum(last) from (select last(tps) from “disk” WHERE (“device” = ‘sdb’ AND “host” =~ /^$host$/) AND $timeFilter GROUP BY time(10s) fill(null)
Could anyone offer some hints on how I can settle this done. Or this is too easy to do this than I get something wrong?