I want to create a table with the result from the JMeter test , which shall consist of transaction name with respect to the count on the basis of http status code. I have the following result as JSON format. I am using Influxdb as my data source. How to do this ?
{
"results": [
{
"statement_id": 0,
"series": [
{
"name": "JMeter_Result",
"columns": [
"time",
"errorCount",
"receivedBytes",
"requestName",
"responseMessage",
"responseTime",
"responsecode",
"samplecount",
"sentBytes",
"status"
],
"values": [
[
"2020-07-13T05:13:19.771Z",
0,
3974,
"T01_Retrieve_Bearer_Token",
"Number of samples in transaction : 1, number of failing samples : 0",
715,
"200",
1,
640,
"Success"
],
[
"2020-07-13T05:13:20.927Z",
0,
4035,
"T01_Retrieve_Bearer_Token",
"Number of samples in transaction : 1, number of failing samples : 0",
702,
"200",
1,
635,
"Success"
],
[
"2020-07-13T05:13:21.707Z",
0,
154840,
"T02_Retrieve_Country_Details",
"Number of samples in transaction : 1, number of failing samples : 0",
1241,
"200",
1,
1682,
"Success"
],
[
"2020-07-13T05:13:22.984Z",
0,
537,
"T04_Add_New_Country",
"Number of samples in transaction : 1, number of failing samples : 0",
159,
"200",
1,
1880,
"Success"
],
[
"2020-07-13T05:13:23.23Z",
0,
3940,
"T01_Retrieve_Bearer_Token",
"Number of samples in transaction : 1, number of failing samples : 0",
690,
"200",
1,
640,
"Success"
],
[
"2020-07-13T05:13:24.001Z",
0,
544,
"T03_Retrieve_Any_Random_Country_Details",
"Number of samples in transaction : 1, number of failing samples : 0",
673,
"200",
1,
1652,
"Success"
],
[
"2020-07-13T05:13:24.625Z",
0,
176816,
"N02_Navvigating_Loging_Page",
"Number of samples in transaction : 2, number of failing samples : 0",
5044,
"200",
1,
9344,
"Success"
],
[
"2020-07-13T05:13:24.695Z",
0,
4027,
"T01_Retrieve_Bearer_Token",
"Number of samples in transaction : 1, number of failing samples : 0",
693,
"200",
1,
648,
"Success"
],
[
"2020-07-13T05:13:25.443Z",
0,
154979,
"T02_Retrieve_Country_Details",
"Number of samples in transaction : 1, number of failing samples : 0",
1140,
"200",
1,
1678,
"Success"
],
[
"2020-07-13T05:13:26.643Z",
0,
4254,
"T01_Retrieve_Bearer_Token",
"Number of samples in transaction : 1, number of failing samples : 0",
685,
"200",
1,
637,
"Success"
],
[
"2020-07-13T05:13:27.372Z",
0,
3958,
"T01_Retrieve_Bearer_Token",
"Number of samples in transaction : 1, number of failing samples : 0",
666,
"200",
1,
641,
"Success"
],
[
"2020-07-13T05:13:28.102Z",
0,
537,
"T04_Add_New_Country",
"Number of samples in transaction : 1, number of failing samples : 0",
674,
"200",
1,
1852,
"Success"
]
]
}
]
}
]
}