hello all , i’m new with influxdb flux query , i’m looking to display list of interfaces information ( If name , If speed , if status , etc ) on the same table view fow and i’m already made a query but i got all that values on same column which i want that different values on separate columns on sa…

I think i made it by using pivot(), kindly if you have more suggestion please advice here example from my query from(bucket: "ltt") |> range(start: -10m ) |> filter(fn: (r) => r["_measurement"] == "interface") |> filter(fn: (r) => r["_field"] == "ifSpeed" or r["_field"] == "ifOperStatus" or r[…

Multiple value on same row table view influxdb 2

Fluxlang

Anaisdg December 15, 2021, 6:34pm 3

@legopixel,
You can also use fieldsAsCol() here which is a just a pivot function for precisely that type of pivot

1 Like

Custumization of Snmp Tables

Topic		Replies	Views
Using Pivot in Flux on InfluxDB data - what am I doing wrong? Fluxlang influxdb , flux	6	902	November 20, 2022
Flux query for multiple tables each with the last value subtracted from all values Fluxlang query , flux	5	778	February 26, 2024
What is wrong with Flux query Fluxlang influxdb , flux	3	360	April 21, 2023
Getting data with last values of different fields Fluxlang flux	1	633	November 17, 2019
Chart can't display several columns in table Dashboards influxdb , flux	3	952	August 4, 2020

Multiple value on same row table view influxdb 2

Related Topics