Smooth over large periods of missing data

Hi,

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:


Those dips aren’t zeroes. They are no data at all.

Is there any way in Grafana to connect the closest values around the gaps that do exist?

Best regards,
Albert.

I don’t use elasticsearch but with influx the Fill option in the query controls what happens when there is no data.

This is what I have for elasticsearch query controls:

There’s that field called “Missing” which sounds like it might be what I need, but I can’t find any docs on how to use it.

Best regards,
Albert.

What do you see if you hover or click on the question mark?

image

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.

Best regards,
Albert.

If you go to “Display”, and then check “Null value”, you can choose connected.

That one doesn’t seem to be doing anything for me either.

“Null” (default):

“Connected”:

Best regards,
Albert.

I get it to work when I have the interval set to ‘auto’, but once I change it to 1d it won’t work unfortunately.

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.

Best regards,
Albert.