Hi Experts, I am using InfluxDB 2.1.1, and Grafana v8.3.2 (afb9e8e5f). The connection is set up with Flux. I want to display basic system logs from a bucket. I have a few variables set on the dashboard and the query for the a table view is set up like this: from(bucket: "log") |> range(start: v…

I realized, I should have used the Overrides and not the Organize Fields transformation. But correct me if I am wrong. But it looks like the Overrides still ignores me the order I maintain the fields. And if I only use Organize Fields to set the column order, that still resets after each time range…

I have hit the same roadblock. I know Grafana is open source but fixing this issue is way beyond my skill level. Would be great if someone could look at this? Thank you Ian Ian

How about usong rename function of flux instead rename() function | Flux 0.x Documentation rename() renames columns in a table.

Thank you. I tried that but the column name to be changed (e.g.) Device {_start="2023-02-18 06: etc etc etc } is diferent every time the data is pulled (diferent time stamps). So I am not sure how I can identify the column to be changed to “Device”. Ian

hmmmmm, I have looked at this again… so maybe if my column name is Device {_start="2023-02-18 06: etc etc etc } , I just need a regex expression to find “Device {_start” (i.e. new regex expression - below) and change “${column} (Reserved)” to “${column} (Device)” ? |> rename( fn: (column)…

Hi @ianhud , Maybe you can just ungroup data and drop _start and _stop columns? Default: Here you can see one column with all tags inside { } brackets and selection box for choosing different tables (in my case they differ in path which is filesystem name). [image] After ungrouping data (…

Thank you… I appreciate your time and effort. I don’t get the same results a you… table 1 [1] if I ungroup I get [2] i.e. cloums have “{_start=xxxx” in their name Ian

Hi @ianhud , If {_start="YYYY-MM-DD"} is part of the column name then try using grafana transformation Rename by regex with: Match: (.*)\s{.* Replace: $1 This regex should extract anything that’s before bracket {. So from: _value {_start="2023-02-18 16:12"} Device {_start="2023-02-18 16:12"} Typ…

[image] ianhud: Device {_start="2023-02-18 06: etc etc etc Why is the data coming like that in first place? Can you share data sample as csv please

I attach 2 files both generated by this code from(bucket: "ashtreedb") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "test") |> group() The file generated by influxdb [image] iCloud.com Sign in to iCloud to access your photos, v…

Organize fields transformation resets after changing variables

Grafana InfluxDB

grant2 February 19, 2023, 2:34pm 15

Very kind indeed @ldrascic

I keep bookmarking your posts because you are solving problems that I will likely encounter in the future!

Topic		Replies	Views
Meta data in column name with Grafana + influxdb + Table panel InfluxDB	5	3141	October 19, 2022
"Transpose" transformation overrides name changes made with a preceding "Organize field by names" Table Panel transformations	2	609	September 16, 2025
How can I change the order of columns in the table panel with flux and grafana 10 Grafana templating	2	8140	March 19, 2024
How to display values from rows as data in columns in a table (using data transformation) InfluxDB influxdb , transformations , flux , visulazation , time-series	13	9723	February 4, 2024
Prettify GROUP BY query results InfluxDB	5	4315	July 30, 2020

Organize fields transformation resets after changing variables

Related topics