InfluxDB

Pivot 
 |> pivot(rowKey: ["_time"], columnKey: ["host"], valueColumn: "_value")
 
 Align Timestamps 
 |> truncateTimeColumn(unit: 5m)
 
 Map 
 |> map(fn: (r) => ({_time: r._time, _value: something}))