I have a measurement looks like this:
hits host 1 server_a 1 server_a 1 server_b
I want to aggregate it into per second like
hits host 2 server_a 1 server_b
WHat’s my best approach to do this?
Everytime I try SELECT COUNT(hits), host … GROUP BY influxdb says
ERR: error parsing query: mixing aggregate and non-aggregate queries is not supported