Aggregate data from same measurement same field but different tag keys

Telegraf
,
1

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 ?

Question

  • 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?