I’ve downloaded NovaTec-APM dashboard that uses JMeter and InfluxDb. Everything works ok, but I’d like to be able to filter results by testName. I tried to edit “metrics overview” graph by adding testName into group by section but it doesn’t work.
Original query:
SELECT count(responseTime) as Count, mean(responseTime) as Avg, min(responseTime) as Min, median(responseTime) as Median, percentile(responseTime, 90) as “90%”,percentile(responseTime, 95) as “95%”,percentile(responseTime, 99) as “99%”, max(responseTime) as Max, (sum(errorCount)/count(responseTime)) as “Error Rate” FROM “requestsRaw” WHERE $timeFilter GROUP BY requestName
Edited query:
SELECT count(responseTime) as Count, mean(responseTime) as Avg, min(responseTime) as Min, median(responseTime) as Median, percentile(responseTime, 90) as “90%”,percentile(responseTime, 95) as “95%”,percentile(responseTime, 99) as “99%”, max(responseTime) as Max, (sum(errorCount)/count(responseTime)) as “Error Rate” FROM “requestsRaw” WHERE $timeFilter GROUP BY requestName, testName
I’m totally new to influxDb but I suspect that it might have something to do with testName field which is not TAGed ? Field is populated just fine in the database, but I just can’t use it in my query. Any advice how to use that field in the query or do I need to do some magical changes to Influxdb table ?