Wrong summary from aggregatwindow ? Reportet Bug

1

Hi,

i gettin wrong sum from aggregatwindow but i don´t know why.

Picture 1 and 2 shows the right values in 24h format. With a calculator i have 4,226 kilowatt hours

If i add the aggregatWindow with sum for 1 month i have the value in picture 3 about 6,638 kilowatt hours

The whole code:

from(bucket: "solarkraftwerk")
  |> range(start: -1mo, stop: now())
  |> filter(fn: (r) => r["_measurement"] == "solarkraftwerk")
  |> filter(fn: (r) => r["_field"] == "todaykwh")
  |> aggregateWindow(every: 24h, fn: max, createEmpty: false)
  |> aggregateWindow(every: 1mo, fn: sum, createEmpty: false)

1
11977×1013 148 KB

2
21898×1018 144 KB

3
31929×1024 118 KB

2

I have searched a bit and InfluxUI does not show all data in RAW Format.

If the Window is resized to 4 records see Picture 2 there are 2 or more records lost.

If i resize the RAW Window to full or to 1 record there are all records here

This is a Bug in Influx UI

Opened an Issue: