Flux with integral

[ebabeshko]

@laurentrioux91

Now I would like to sum them per each day (to get the total kwh per day)

Try something like this:

 |> aggregateWindow(every: 1d, fn: sum, createEmpty: false, timeSrc: "_start")

See also this thread with similar discussion:

Influxdb2: Combining last + sum to get weekly values

What Grafana version and what operating system are you using? Grafana 9.3.2 What are you trying to achieve? Visualize in a bar graph the weekly consumption based on daily values for one month How are you trying to achieve it? import “timezone” option location = timezone.location(name: “Europe/Berlin”) from(bucket: “iobroker”) |> range(start: -1mo, stop: now()) |> filter(fn: (r) => r[“_measurement”] == “HausverbrauchKwh” and r[“_field”] == “value”) |> aggregateWindow(every: 24h, f…