I’m having the following issue in Grafana - when there is no data, it draws a straight line:
I’m guessing the issue stems from top() not returning nulls for missing data unlike percent() is:
{
"xhrStatus": "complete",
"request": {
"method": "GET",
"url": "api/datasources/proxy/1/query",
"params": {
"db": "data",
"q": "SELECT top(\"response_time\", 3) FROM \"response_time\" WHERE (\"test_name\" =~ /^2018-08-13 16:14:26 CET v0\\.7\\.1\\.1-beta f3\\.0\\.1$/ AND \"user_count\" =~ /^(0|1|50|150)$/) AND time >= 1534170045976ms and time <= 1534170174427ms GROUP BY time(5s);SELECT percentile(\"response_time\", 95) FROM \"response_time\" WHERE (\"test_name\" =~ /^2018-08-13 16:14:26 CET v0\\.7\\.1\\.1-beta f3\\.0\\.1$/ AND \"user_count\" =~ /^(0|1|50|150)$/) AND time >= 1534170045976ms and time <= 1534170174427ms GROUP BY time(5s);SELECT percentile(\"response_time\", 75) FROM \"response_time\" WHERE (\"test_name\" =~ /^2018-08-13 16:14:26 CET v0\\.7\\.1\\.1-beta f3\\.0\\.1$/ AND \"user_count\" =~ /^(0|1|50|150)$/) AND time >= 1534170045976ms and time <= 1534170174427ms GROUP BY time(5s)",
"epoch": "ms"
},
"data": null,
"precision": "ms"
},
"response": {
"results": [
{
"statement_id": 0,
"series": [
{
"name": "response_time",
"columns": [
"time",
"top"
],
"values": [
[
1534170046148,
745.5370426177979
],
[
1534170047071,
922.8630065917969
],
[
1534170049288,
793.4260368347168
],
[
1534170051682,
871.2010383605957
],
[
1534170052540,
857.7220439910889
],
[
1534170053400,
859.35378074646
],
[
1534170055697,
859.3149185180664
],
[
1534170056497,
800.2240657806396
],
[
1534170057306,
808.4871768951416
],
[
1534170060260,
827.2311687469482
],
[
1534170061012,
752.0780563354492
],
[
1534170061976,
963.1259441375732
],
[
1534170149829,
2496.7470169067383
],
[
1534170149842,
2494.2798614501953
],
[
1534170149853,
2515.634059906006
],
[
1534170151711,
4312.8039836883545
],
[
1534170151711,
4365.154981613159
],
[
1534170151962,
4584.737062454224
]
]
}
]
},
{
"statement_id": 1,
"series": [
{
"name": "response_time",
"columns": [
"time",
"percentile"
],
"values": [
[
1534170045000,
922.8630065917969
],
[
1534170050000,
871.2010383605957
],
[
1534170055000,
859.3149185180664
],
[
1534170060000,
963.1259441375732
],
[
1534170065000,
null
],
[
1534170070000,
null
],
[
1534170075000,
null
],
[
1534170080000,
null
],
[
1534170085000,
null
],
[
1534170090000,
null
],
[
1534170095000,
null
],
[
1534170100000,
null
],
[
1534170105000,
null
],
[
1534170110000,
null
],
[
1534170115000,
null
],
[
1534170120000,
null
],
[
1534170125000,
null
],
[
1534170130000,
null
],
[
1534170135000,
null
],
[
1534170140000,
null
],
[
1534170145000,
2496.7470169067383
],
[
1534170150000,
4365.154981613159
],
[
1534170155000,
null
],
[
1534170160000,
null
],
[
1534170165000,
null
],
[
1534170170000,
null
]
]
}
]
},
{
"statement_id": 2,
"series": [
{
"name": "response_time",
"columns": [
"time",
"percentile"
],
"values": [
[
1534170045000,
793.4260368347168
],
[
1534170050000,
857.7220439910889
],
[
1534170055000,
808.4871768951416
],
[
1534170060000,
827.2311687469482
],
[
1534170065000,
null
],
[
1534170070000,
null
],
[
1534170075000,
null
],
[
1534170080000,
null
],
[
1534170085000,
null
],
[
1534170090000,
null
],
[
1534170095000,
null
],
[
1534170100000,
null
],
[
1534170105000,
null
],
[
1534170110000,
null
],
[
1534170115000,
null
],
[
1534170120000,
null
],
[
1534170125000,
null
],
[
1534170130000,
null
],
[
1534170135000,
null
],
[
1534170140000,
null
],
[
1534170145000,
2143.4969902038574
],
[
1534170150000,
4077.6400566101074
],
[
1534170155000,
null
],
[
1534170160000,
null
],
[
1534170165000,
null
],
[
1534170170000,
null
]
]
}
]
}
]
}
}
How can I fix this?
