Open keeks5 opened 1 year ago
Hi,
Using Grafana 9.2.4. And got that error. It does not tell me what field exactly but.
{ "request": { "method": "GET", "url": "api/datasources/proxy/1569/query", "params": { "db": "so_tools", "q": "select mean(loss) as loss,mean(rtt) as rtt from tracebot_results group by hop, ip, host, dest", "epoch": "ms" }, "data": null, "precision": "ms", "hideFromInspector": false }, "response": { "results": [ { "statement_id": 0, "series": [ { "name": "tracebot_results", "tags": { "dest": "", "hop": "", "host": "", "ip": "" }, "columns": [ "time", "loss", "rtt" ], "values": [ [ 0, 0, 55.583333333333336 ] ] } ] } ], "executedQueryString": "select mean(loss) as loss,mean(rtt) as rtt from tracebot_results group by hop, ip, host, dest" } }
Did not understand why in the example query has "select mean(avg) as rtt, mean(loss) as loss from" <-- avg there , what is that?
That query wont work either, returns null for the first field as don't have filed "avg"
BR, Keeks
Hi,
Using Grafana 9.2.4. And got that error.
It does not tell me what field exactly but.
{ "request": { "method": "GET", "url": "api/datasources/proxy/1569/query", "params": { "db": "so_tools", "q": "select mean(loss) as loss,mean(rtt) as rtt from tracebot_results group by hop, ip, host, dest", "epoch": "ms" }, "data": null, "precision": "ms", "hideFromInspector": false }, "response": { "results": [ { "statement_id": 0, "series": [ { "name": "tracebot_results", "tags": { "dest": "", "hop": "", "host": "", "ip": "" }, "columns": [ "time", "loss", "rtt" ], "values": [ [ 0, 0, 55.583333333333336 ] ] } ] } ], "executedQueryString": "select mean(loss) as loss,mean(rtt) as rtt from tracebot_results group by hop, ip, host, dest" } }
Did not understand why in the example query has "select mean(avg) as rtt, mean(loss) as loss from" <-- avg there , what is that?
That query wont work either, returns null for the first field as don't have filed "avg"
BR, Keeks