Warning! This page documents an earlier version of Flux, which is no longer actively developed. Flux v0.50 is the most recent stable version of Flux.
The influxFieldsAsCols()
function is a special application of the pivot()
function that
automatically aligns fields within each input table that have the same timestamp.
Function type: Transformation
influxFieldsAsCols()
Examples
from(bucket:"telegraf/autogen")
|> range(start: -1h)
|> filter(fn: (r) => r._measurement == "cpu")
|> influxFieldsAsCols()
|> keep(columns: ["_time", "cpu", "usage_idle", "usage_user"])
Function definition
influxFieldsAsCols = (tables=<-) =>
tables
|> pivot(
rowKey:["_time"],
columnKey: ["_field"],
valueColumn: "_value"
)