How to make sense of Gatling measurements published to InfluxDb?

Gatling (Open-Source)
1

Hello Team,

I was able to get the Gatling metrics published to InfluxDb via Graphite, but these metrics are split into multiple measurements. Using Influx Query Language I am are trying to combine metric data from multiple measurements and make it available on Grafana panels.

I see the following measurements in my influxDB

eg : Measurements:

gatling.windtunnelopenworkload.allRequests.all.percentiles50

gatling.windtunnelopenworkload.allRequests.all.percentiles75

gatling.windtunnelopenworkload.allRequests.all.percentiles95

gatling.windtunnelopenworkload.allRequests.all.percentiles99

All these measurements have same measurement fields:

fieldKey fieldType

value float

Question : How am i supposed to query a measurement to get 50 percentile reading ?

SELECT last(value) FROM “gatling.windtunnelopenworkload.allRequests.all.percentiles50” WHERE $timeFilter

OR
SELECT mean(value) FROM “gatling.windtunnelopenworkload.allRequests.all.percentiles50” WHERE $timeFilter

Best Regards,
Anup

2

Have not found a way to get the exactly the same result as shown in gatling summary.
I have asked the similar question in the stackoverflow as well: https://stackoverflow.com/questions/70865401/any-ready-made-solution-to-save-the-gatling-summary-report-to-database-for-visua

The influxdb+grafana+graphite solution is more like for trend following, but not for storing the results.

BR,
Chunyan Pei