Merge table after a group without _time

Question

Hello i'm trying to have a graph who give me the mean value of a time series by hour during x Days

I've succeeded to have the mean value but now all value are in different table and i don't know how to merge the table.

I've seen merge or union function but i don't understand how to use them in a pipe

import "date"

from(bucket: "myBucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "°C")
  |> filter(fn: (r) => r["_field"] == "value")
  |> filter(fn: (r) => r["someField"] == "aValue")
  |> map(fn: (r) => ({r with hour: date.hour(t: r._time)}))
  |> group(columns: ["hour"])
  |> mean()

My goal is to have all value in the same table and have a graph not just dot in influxd dashboard

score 0 · Answer 1 · answered Nov 03 '22 at 12:50

I'd suggest using aggregateWindow, I believe it does what you are trying to achieve.

from(bucket: "myBucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "°C")
  |> filter(fn: (r) => r["_field"] == "value")
  |> filter(fn: (r) => r["someField"] == "aValue")
  |> aggregateWindow(every: 1h, fn: mean)

Merge table after a group without _time

1 Answers1