I have a weekly Influx stat query that works ok however, it starts from a monday at 01:00 rather than 00:00. The date and time of the serving VM is correct.
import "experimental/date/boundaries"
day = boundaries.week()
from(bucket: "buckett")
|> range(start: day.start, stop: day.stop)
|> filter(fn: (r) => r["_measurement"] == "kwh")
|> filter(fn: (r) => r["_field"] == "kwh")
|> spread()
|> yield(name: "stat_for_yesterday_kwh")
I’ve tred fiddling with the time zone Europe/London that makes no difference
As seen ‘watt-hours’ differs from ‘Week’
Also ‘Yesterday’ does the same thing.
import "experimental/date/boundaries"
day = boundaries.yesterday()
from(bucket: "buckett")
|> range(start: day.start, stop: day.stop)
|> filter(fn: (r) => r["_measurement"] == "kwh")
|> filter(fn: (r) => r["_field"] == "kwh")
|> spread()
|> yield(name: "stat_for_yesterday_kwh")