(don’t mind the 10y aggregate window. Without this it doesn’t work)
This works fine, it returns a single point with the consumed energy and displays it into a gauge.
Now I want to filter by certain hours. So I use hourSelection():
Hello @Marti_B,
It’s hard to tell without looking at the annotated CSV.
Can you verify that you have data in that time period? Also I believe you want to reverse the stop and start times. I
This needs to be done before calling aggregateWindow to aggregate the data. Once you use any aggregate, the original times are lost and aggregateWindow will only likely return one row anyway because of the long period time period. I’d probably go with something like this instead (after the filter).
This is effectively what aggregateWindow does, but you’re skipping the windowing part and just getting the stop time directly. It should also improve the speed of the query.