InfluxDB: Total AC channel

[broth-itk]

Thanks for your great dashboard!
I really enjoy using it :)

I missed to see the total AC power in the diagram "Leistungsverlauf".

This is my proposal:

Calculated:

from(bucket: "${bucket_opendtu}")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "output")
  |> filter(fn: (r) => r["_field"] == "power")
  |> aggregateWindow(every: 30s, fn: max, createEmpty: false)
  |> group(columns: ["_time"], mode: "by")
  |> sum(column: "_value")  
  |> group()
  |> yield(name: "total")

Using "output_per_dtu" measurement (better performance)

from(bucket: "${bucket_opendtu}")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "output_per_dtu")
  |> filter(fn: (r) => r["_field"] == "power")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "total")

[smainz]

Thanks for yout input,did never miss it.

As one can have multiple DTUs, I would use a combination of both of the queries:

from(bucket: "${bucket_opendtu}")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "output_per_dtu")
  |> filter(fn: (r) => r["_field"] == "power")
  |> aggregateWindow(every: 10s, fn: max, createEmpty: false)
  |> group(columns: ["_time"], mode: "by")
  |> sum(column: "_value")  
  |> group()
  |> yield(name: "total")

I will release a new version after hollidays including this and a long term chart.

[broth-itk]

Thanks for your update! I added the combination and it works just fine.

Attached a screenshot for yesterdays results. I wouldn't miss it if I had only a few panels which point to the same direction.
But in my case they point to different cardinal directions to compensate shading. The total value starts to make sense.

Enjoy your holidays!