My task doesn’t feel like something uncommon, but I haven’t found answers on the community, therefore apologies if it’s a duplicate.
Datasource: elasticsearch
Grafana: 6.2.5
New data normally comes in every 24 hours, and interval in Grafana is set to 1d. However, there are sometimes large periods of time when no data comes in, which results in graphs like this one:
A quick google suggests that is a feature of the elasticsearch query, you could try there for details if you haven’t already. Perhaps someone else with knowledge of elasticsearch can help.
There appears to be content validation on that field - I can input either a number or, oddly, letter ‘e’; no other letter is accepted. It also doesn’t accept either [], {} or () which I think would prevent elasticsearch queries from being used in that field.
I’ve also tried to input a very large number (comparatively to other values I have on the graph) into the field in an attempt to see if it would do anything, and it didn’t.
Auto didn’t work for me, that’s why I had to go with 1d. But if I change it to the combo of auto and connected, the graph gets worse than it was prior to the change.