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[…

@legopixel , You can also use fieldsAsCol() here which is a just a pivot function for precisely that type of pivot schema.fieldsAsCols() function | Flux 0.x Documentation schema.fieldsAsCols() is a special application of pivot() that pivots input data on _field and _time columns to alig…

thanks for supporting , will try it

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

Custumization of Snmp Tables

Topic		Replies	Views
Showing Switch Port Status in a single table using multiple queries Grafana influxdb , telegraf , flux	6	213	July 1, 2024
Problem with pivot() in specifying rows and coloums InfluxDB 2	13	149	September 21, 2025
Select Multiple Columns in FLUX InfluxDB 2 flux	2	575	June 14, 2023
Table view with multiple fields from multiple measurements/tables with where clause InfluxDB 2 influxdb , grafana , flux	3	2540	April 20, 2022
Display several columns in a board InfluxDB 2 influxdb , time-series , influxdata , query , flux	3	1273	April 13, 2022

Multiple value on same row table view influxdb 2

Related topics