How to find sum of top two rows on influxdb

[Dhana_Krishnasamy]

Hi,
I have telegraf collect process count across few machines. The collected data in influx db is in the format

time processa_name count host
123434 telegraf 1 host1
123435 telegraf 1 host2
123334 telegraf 1 host1
123335 telegraf 1 host2
…

How could I find the current count across all hosts (here is 2)? Basically I need sum of last of count. Any help is appriciated.

Thanks
Dhana

[Pooh]

Have you tried something like:

select sum(last) from (select last(count) from table group by host)

…presumably with an appropriate time condition as well?

Antony.

[Dhana_Krishnasamy]

cool, that helps, with correct time window selecting it works… thanks Antony