InfluxDB

Pivot

  |> pivot(rowKey: ["_time"], columnKey: ["host"], valueColumn: "_value")

Align Timestamps

  |> truncateTimeColumn(unit: 5m)

Map

  |> map(fn: (r) => ({_time: r._time, _value: something}))