Hello, I’m trying to create a new column in my series, using _measurement value as prefix.
Is there any way to make it?
I need that because I’m aggregating some series but I would like to keep the real timestamp for each serie as a new column in my pivot result. So I would have something similar to it.
_time | measurement_1 | _time_measurement_1 | measurement_2 | _time_measurement_2
12311 | 50 | 12322 | 60 | 12320
Example of query
from(bucket: "test")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop )
|> filter(fn: (r) => r["_field"] == "value")
|> aggregateWindow(every: 10s, fn: last, createEmpty: false)
|> limit(n: 1000)
|> pivot(rowKey:["_time"], columnKey: ["_measurement"], valueColumn: "_value")
|> drop(columns: ["_start", "_stop", "_field"])
thank you