I have below data in grafana, coming from influxDB.
Data in InfluxDB :
I am using Influx DB 1.7 with Grafana. When i display above data in Grafana the Client Names are coming with () like Res1(4234), Res2(4254)… But i want to display Client Names in Grafana as Res1, Res2 like below.
Grafana Table :
I am writing grafana sql query as below.
Select Code,id,Client_Name,Policy from xtable
How can i trim (4234) paranthesis with numbers from Client_Names in Grafana sql.
You are right. But the data is influxdb. I have 10.000 s of data like this. InfluxDB does not allow to update added records.It is a time series db. Do you know Influxdb ? Is it possbile to clean these pharanthesis () in Influxdb database side?