InfluxDB – Power consumption

daily_power_consumption

  from(bucket: "home_assistant")
  |> range(start: -30d)
  |> filter(fn: (r) => r._measurement == "imp" and r._field == "value")
  |> aggregateWindow(every: 1d, fn: spread, createEmpty: false)
  |> map(fn: (r) => ({r with _value: r._value / 1000.0 }))
  |> yield(name: "daily total")

weekly_power_consumption

  from(bucket: "home_assistant")
  |> range(start: -60d)
  |> filter(fn: (r) => r._measurement == "imp" and r._field == "value")
  |> aggregateWindow(every: 1w, fn: spread, createEmpty: false)
  |> map(fn: (r) => ({r with _value: r._value / 1000.0 }))
  |> yield(name: "weekly total")