@Monk aggregateWindow use the _stop column of each 1d window as the new _time value of the aggregate points. So where “today” is still in progress, you get a partial window and that _stop time of the window is essentially now(). One thing to also note is that because it’s using the _stop time of each window as the new _time, the value is actually that of the previous day.
To solve this, I’d recommend specifying the _start as the timeSrc in aggregateWindow():
@scott, many thanks, works like a charm. Still a lot to learn. Although I’m every time amazed by the power of InfluxDB, sometimes it feels like black magic. Thankfully there is such a supportive community.