InfluxDB 2.0 | Query Data and aggregate multiple times

Question

I have a photovolatic system and log the generated electricity in KwH at each change in an InfluxDB 2.0.

Now I want to have a graph of the monthly yields in Grafana. For this I need to load the last value of the day and sum it up per month. Actually a simple query, but unfortunately I can't get it implemented.

The following query I tried and expected it to work:

from(bucket: "Home Assistant") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "sensor.kaco_29") |> filter(fn: (r) => r["_field"] == "kwh_today") |> aggregateWindow(every: 1d, fn: last) |> aggregateWindow(every: 1m, fn: sum)

Loading the last daily value works, without the last line without any problems. How do I get the data summed up per month?

FractalDoctor · Accepted Answer · 2021-06-08 20:56:25Z

0

Did you try grouping after the first aggregation?

Add

|> group()

between the two aggregateWindow() functions.

answered Jun 8, 2021 at 20:56

FractalDoctor

2,56623 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

InfluxDB 2.0 | Query Data and aggregate multiple times

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related