Hello.
I use Grafana with Zabbix plugin for some time.
So I’m not fasting and I start thinking of being dense.
I wanted to change a display type by switching to the staus panel.
To avoid problems I created a new panel.
I think it’s simple but it does not work.
As data source I use the same one I use for other graphs.
I choose the desired metric and the query inspector returns me the correct data (ping times to a host).
I insert the title, and the alias, use last as aggregation.
As thresholds I use 0.02 and 0.03 (2 and 3 ms, the values are those returned by the query inspector) but I also tried with 2-3 or 20-30. I also tried to remove the threshold (text only) and to display the value … Nothing!
In the panel I always see only the panel title and the green color.
Qhat am I doing wrong? I’m going crazy!
{
“xhrStatus”: “complete”,
“request”: {
“method”: “POST”,
“url”: “api/tsdb/query”,
“data”: {
“queries”: [
{
“refId”: “A”,
“format”: “time_series”,
“datasourceId”: 1,
“rawSql”: “SELECT CAST(itemid AS CHAR) AS metric, clock DIV 10 * 10 AS time_sec, AVG(value) AS value FROM history WHERE itemid IN (58284) AND clock > 1552036674 AND clock < 1552043874 GROUP BY clock DIV 10 * 10, metric ORDER BY time_sec ASC”,
“maxDataPoints”: 10000
}
]
}
},
“response”: {
“results”: {
“A”: {
“refId”: “A”,
“meta”: {
“rowCount”: 0,
“sql”: “SELECT CAST(itemid AS CHAR) AS metric, clock DIV 10 * 10 AS time_sec, AVG(value) AS value FROM history WHERE itemid IN (58284) AND clock > 1552036674 AND clock < 1552043874 GROUP BY clock DIV 10 * 10, metric ORDER BY time_sec ASC”
},
“series”: [
{
“name”: “58284”,
“points”: [
[
0.04175,
1552036670000
],
[
0.040925,
1552036680000
],
…
