I have been working on influx DB & Grafana integration in order to create dashboard for jmeter performance tests in real time.
Both Influx Db & Grafana had been installed on the local machine. Samples of jmeter tests can be seen in the Grafana dashboard Table & graphs options.
Requirement is to create a table having multiple columns
First column would be txn name like TS01_01_Launch
Second column should have value of ok.avg sample
Third column should have value of ok.max sample and so on.
Can you assist me in order to write a query under table option to create a table having multiple columns by using different samples.
As of now i am able to create table having values of only one sample like ok.avg or ok.min.
Can you assist me in order to write a query under table option to create a table having multiple columns by using different available samples. for example
First column would be txn name like TS01_01_Launch
Second column should have value of ok.avg sample
Third column should have value of ok.max sample and so on.
Can you assist me in order to write a query under table option to create a table having multiple columns by using different available samples. for example
First column would be txn name like TS01_01_Launch
Second column should have value of ok.avg sample
Third column should have value of ok.max sample and so on.
The closest I could get to what you want is to use the Time series aggregations option and then choose the avg, min and max aggregations but that looks like it conflicts with your data. I don’t think the Table Panel is flexible enough to to do what you want.
As a side issue, I think you could make your query simpler by using regex. Something like:
you need to store your values as separate fields (avg, count, max, min, etc) not as separate measurements. Then you could write it as a query that returns a table.
All the values are being captured as a separate measurements automatically.
Can you please assist me to make separate fields.
Cant we say that jmeter.TS01_01_Launch.ok.avg , jmeter.TS01_01_Launch.ok.min are seperate fields of .ok sample.
I’m not sure. Can you select multiple fields in one query rather than have lots of queries? You can get to the fields menu by clicking on the plus sign beside select.
Could you please help me to add other sample transactions in subsequent rows of above table also want to change the name of second column to avg. and so on…