Just upgraded to OSS 2.6, and the graphs now seem to ignore the “stop” value in terms of visualization. The query produces results up to the stop time, but the graph treats stop as “now”. The behavior was as expected in 2.3.
Is there a work-around for this?
FWIW this is my query. It works as expected if the current time of day is after 10AM and before 8PM, but outside of those hours the graph “stop” time is current time.
import “timezone”
import “experimental”
import “date”
option location = timezone.fixed(offset: -10h)
date = if date.hour(t: now()) >= 11 then today() else experimental.subDuration(d: 24h, from: today())
startoffset = 6h
duration = 14h
start = experimental.addDuration(d: startoffset, to:date)
stop = experimental.addDuration(d: duration, to: start)
startYesterday = experimental.subDuration(d: 24h, from: start)
stopYesterday = experimental.subDuration(d: 24h, from: stop)
today = from(bucket: “Iotabucket2”)
|> range(start: start, stop: stop)
|> filter(fn: (r) => r[“ct”] == “PV”)
|> yield(name: “Watts”)
|> aggregateWindow(fn: mean, every: 30m, createEmpty: false)
|> yield(name: “Average”)
from(bucket: “Iotabucket2”)
|> range(start: startYesterday, stop: stopYesterday)
|> filter(fn: (r) => r[“ct”] == “PV”)
|> timeShift(duration: 24h)
|> aggregateWindow(fn: mean, every: 10m)
|> yield(name: “Yesterday”)
