Hello, First of all, I am using Grafana version 8.0.5. I have a set of data looking like that: /v2/ports/PF-12345 /v2/services/cloud/PF-67891 /v2/services/cloud/connections/PF-123467 I am trying to modify this data set like below (basically removing v2 and the ID at the end of the URL. ports ser…

Hello @melori.arellano , I was able to upgrade Grafana to 8.5 and use the Value Mapping feature. Now I end up with a table cleaned up without any ID which is great. Now, how can I do some post-processing on the result after value mapping? For example, using Value Mapping, I end up with: Port Clou…

What is the source of this data? A database? A rest api? A file?

@yosiasz it is an elastic search database and the data are logs coming from GrayLogs ( Elasticsearch )

Elasticsearch has json document data. Please post one sample json document data.

[image] yosiasz: Elasticsearch has json document data Here is the sample data: { "state": "Done", "series": [ { "refId": "A", "fields": [ { "config": { "filterable": true }, "name": "timestamp", …

Transform data using Regular Expression

Grafana Dashboards

melori.arellano September 27, 2022, 2:21am 2

Welcome to the community @romain!

I answered a similar post here that you might find helpful.

Topic		Replies	Views
Transform Rename by Regex not working Elasticsearch dashboard	0	685	August 31, 2023
How to trim some part of selected data from InfluxDB in Grafana InfluxDB	6	5092	December 24, 2021
How to Rename Values in Grafana Using Regex-Based Value Mapping How To value-mapping , user-essentials , transformations , regex	6	116318	October 5, 2022
Cleaning up the Legend Dashboards	11	285	December 11, 2024
Rename by Regex on a Table Grafana	2	6389	October 5, 2021

Transform data using Regular Expression

Related topics