Truncate fields in Table

[martin399a]

Hi, I’m using Grafana v11.0.0 on a Rasberry.
I built a Dashbord showing me electrical currents:

I query IO-Broker via the Infinity-JSON-Datasource and as a Result I get a Table:

I would like to get rid of the long string and just showing “I1”, “I2”, …
I also would like to get rid of the string “val”

The Dashboard is “Stat”-Panel with “show all values” and fields set to “val”

I already tried “Transformations” and “Overrides” but they all go for the Table Header “id” etc. not for the “modbus…”

Regards
Martin

[martin399a]

Hi,
sorry for the post, when writing my post, I had another idea:
I first did a transformation in the Table “Rows to field”

Then a second transformation to tidy up the name with Regex.

Here the result:

Regards
Martin