I recenlty started influxdb with jmeter but I stuck with this error for a while now ERR: aggregate function required inside the call to elapsed.
I have browsed some post here and there but havent found any usefull information so far. That’s why I’m requesting the help of this forum.
In a nutshell I have created a plugin in jmeter. This plugin is sending something and receiving an ack. Jmeter is logging in influxdb all these operations.
I end up with a table of operations. On each line of the table I have the timestamp, the operation type and the operation ID. For each operation ID I have 2 line, the receive and the ack.
What I want to do now is to get the average elapsed time for the total operation (time diff between send and ack) per second.
The query I started to write is the following:
select mean(elapsed_time) from (select elapsed(op_type,1ms) as elapsed_time from operations group by op_correl_id) where time >= 1527522277003ms and time <= 1527522370305ms group by time(1s)
But I get the error above.
The subquery is working fine. I get the elapsed time for each operation. Getting the average of it (mean) works as well. But when I try to group by 1s it fail. But that’s the all point. I don’t want to get the global mean. I want to follow the evolution of this mean over time when I’m actually sending traffic via jmeter.
Let me know if you need any extra information.
Thanks in advance for your help,