Grafana selects from influxDB min Time interval

Grafana
1

Hello all, hope I can get some info on this one.

SELECT sum(“tbl1”) / sum(“tbl2”) FROM “db1” WHERE $timeFilter AND tbl2 > 0 and tbl1 > 0 GROUP BY time($interval), column1 fill(0)

When I use this on a stacked graph, perodicaly data will disapear. There is no rhyme or reason. If I edit the graph and set the min interval to 2m the graph works fine. I would like to know if this is a limitation of grafana or my select?

Thanks

2

You need to set the min interval properly the data source setting , set this to your collection interval

1 Like
3

If it’s not that it’s a problem with you query or data that is causing the issue