How to make sense of Gatling measurements published to InfluxDb ?

[anup kumar]

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

[Maya Pei]

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