Group by query results from influxdb show in incorrect order in grafana table


The json response from influxdb seems to be in correct order. It is grouped by id and name.

But in grafana the table populates it incorrectly

Can someone help me ?

Below is the json response

{
“results”: [
{
“statement_id”: 0,
“series”: [
{
“name”: “report”,
“tags”: {
“id”: “7”,
“name”: ““Global Information””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224722479,
361,
842,
2937,
5301,
210,
0,
6496,
795,
35,
210,
4.666667,
“scenario2-loggedin-search”,
1088
]
]
},
{
“name”: “report”,
“tags”: {
“id”: “7”,
“name”: ““HomePage””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224722479,
4945,
5819,
7040,
7430,
8,
0,
7528,
4905,
2606,
8,
0.177778,
“scenario2-loggedin-search”,
1487
]
]
},
{
“name”: “report”,
“tags”: {
“id”: “7”,
“name”: ““LoginPage””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224722479,
432,
615,
885,
887,
8,
0,
888,
518,
247,
8,
0.177778,
“scenario2-loggedin-search”,
224
]
]
},
{
“name”: “report”,
“tags”: {
“id”: “7”,
“name”: ““Perform Successfull Login””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224722479,
4805,
7394,
9572,
10011,
6,
0,
10121,
5776,
3369,
6,
0.133333,
“scenario2-loggedin-search”,
2509
]
]
},
{
“name”: “report”,
“tags”: {
“id”: “7”,
“name”: ““Search Page - search terms””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224722479,
1560,
1968,
2400,
2503,
6,
0,
2529,
1655,
1094,
6,
0.133333,
“scenario2-loggedin-search”,
517
]
]
},
{
“name”: “report”,
“tags”: {
“id”: “8”,
“name”: ““Global Information””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224930526,
399,
1053,
4581,
6591,
165,
0,
7142,
1071,
57,
165,
3.666667,
“scenario2-loggedin-search”,
1513
]
]
},
{
“name”: “report”,
“tags”: {
“id”: “8”,
“name”: ““HomePage””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224930526,
7574,
7970,
8300,
8375,
7,
0,
8394,
6913,
4818,
7,
0.155556,
“scenario2-loggedin-search”,
1311
]
]
},
{
“name”: “report”,
“tags”: {
“id”: “8”,
“name”: ““LoginPage””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224930526,
552,
650,
749,
768,
6,
0,
773,
561,
396,
6,
0.133333,
“scenario2-loggedin-search”,
134
]
]
},
{
“name”: “report”,
“tags”: {
“id”: “8”,
“name”: ““Perform Successfull Login””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224930526,
5471,
7105,
8210,
8431,
4,
0,
8486,
5730,
3493,
4,
0.088889,
“scenario2-loggedin-search”,
1968
]
]
},
{
“name”: “report”,
“tags”: {
“id”: “8”,
“name”: ““Search Page - search terms””
},
“columns”: [
“time”,
“50thpct”,
“75thpct”,
“95thpct”,
“99thpct”,
“TotalRequests”,
“ko”,
“max”,
“mean”,
“min”,
“ok”,
“reqPerSec”,
“simulation”,
“stddev”
],
“values”: [
[
1510224930526,
1678,
1948,
2158,
2200,
4,
0,
2210,
1743,
1404,
4,
0.088889,
“scenario2-loggedin-search”,
319
]
]
}
]
}
]
}

Hi,

It’s a bit unclear how you expect the result to be ordered. But looking at the screenshot I can see that you’ve sorted the table by the column 50thpct. It’s up to you how you want to order the result in Grafana.

Hope this helps

Marcus