Gaps in the display of data

zabbix

#1

Hello.

After upgrading both Grafana (v.4.6.3) and Zabbix Plugin (v.3.8.1) I’ve get gaps on some graphs in one dashboard:
2018-02-12_9-36-12

The same metric displays in another dashboards without any problem. I cannot figure out why It’s happen and before recreating dashboard with problems I want to know how can I fix dashboard without it.


#2

During further problem investigation I found than gaps depend on time range selected - when I select “last 1 hour” or “last 6 hours” I see normal graph, when “last 3 hours” - graph with gaps.


#3

Could you share your panel’s query?


#4

rowCount 650

sql SELECT itemid AS metric, clock DIV 15 * 15 AS time_sec, AVG(value) AS value FROM history WHERE itemid IN (96539) AND clock > 1519016970 AND clock < 1519027770 GROUP BY clock DIV 15 * 15, metric ORDER BY time_sec ASC


#5

Grafana v.5.0.0 - problem still the same


#6

Grafana v5.1.0 - problem still the same


#7

Have you tried this setting?


#8

Excellent! This setting resolve my issue. Thank you!