Connect empty null values

Greeting dear fellas,

I have a problem with the appearance of my panels. As demonstrated by the screenshot below, the value connects to the next values. I want it to go straight down if the next value is so far away.


I concluded that I must use “Connect null values” to sort out this difficulty. But there are no null values, as you can see in the next screenshot.


So, I think the issue could be resolves if there are not only the given values. If every 15 min there was also an object given with a null object,
Like every “A” has a whole table with an interval every 15 minutes given and some of them have a value, the rest is just empty has null objects.
I think it would work. But I have no clue, where in my code below I sorted the empty value out, or I could get them back.

  • ${_errorcase:regex} is a dynamic filter. I don’t think it is important for this part.
  • "${Sum_or_Single} is a custom variable with r._field or _field
  • highest_value I guess is not relevant. It is a function that puts a new value in the panel that makes it possible to adjust the height of the whole panel via a custom variable. (Because it is not implemented yet in Grafana)
_data = from(bucket: v.bucket)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._measurement == "test")
|> filter(fn: (r) => r.ne_id =~ /^test_server.*/)
|> filter(fn: (r) => r._field =~ /^test_field/)
|> filter(fn: (r) => r._field !~ /^.*_SUCCESS_.*/)
|> filter(fn: (r) => r._field =~ /^.*${_errorcase:regex}.*/)
|> group(columns: ["${Sum_or_Single}"])

|> aggregateWindow(every: 15m, fn: sum, createEmpty: false)

highest_value = _data
|> group(columns: ["r._field"])
|> first()
|> map(fn: (r) => ({r with _value: ${max_hight} }))
|> yield(name: "highest_value")

I use Grafan Version 9.4.7

Please, can you tell which point I am missing here? I can’t get my head around this one. :face_with_spiral_eyes:

A nice person at work helped with this.
The solution is:

|> aggregateWindow(every: 15m, fn: sum, createEmpty: true)


|> aggregateWindow(every: 15m, fn: sum)