Get rid of first entry (double entry)


I am new to InfluxDB and Grafana and did not find an answer yet on the community pages. How to get rid of the first entry. The series should start with the first day/month. But at the beginning my series starts with the double first day of the month (midnight).

Thank you!

Welcome @plutoiceteareindeer to the Grafana forum.

There are probably a few ways to do this, but I think just adding this filter statement after your aggregateWindow statement will do the trick.

import "date"

... your query here ...
|> filter(fn: (r) => date.hour(t: r._time) != 0)
|> yield (name: "mean")

You could also try using the hourSelection function and limit the values returned to the 01:00 hour every day, such as:

|> hourSelection(start: 1, stop: 2)

Thank you for guiding me into the right direction!

Actually, this is working for me.

|> filter(fn: (r) => date.hour(t: r._time) == 0)