Is it possible to make un-pivot with Flux ?
The main reason is to rename value in particular column. I am able to make pivot, rename value but not able to unpivot back so I can display renamed value rather than original one.
Another approach could be to have a function to rename value(s) if possible rather than just column.
See my example below trying to rename value but failing to making unpivot…
from(bucket: "test")
|> range($range)
|> filter(fn: (r) =>
r._measurement == "fautest" and
r.trigger =~ /interval/ and
r._field =~ /green/)
|> group(columns: ["_time", "_value", "trigger", "msgid"], mode: "except")
|> sum(column: "_value")
|> map(fn:(r) => ({
r with
_field: r._field,
_value: r._value * 30}))
|> pivot(rowKey:["_start"], columnKey: ["_field"], valueColumn: "_value")
|> rename(columns: {green: "GREENXXX"})
,result,table,_measurement,_start,_stop,GREENXXX
,,0,fautest,2020-01-22T12:58:11.333219107Z,2020-01-24T12:58:11.333219107Z,27810