Convert field type for every field except Time

I want to change every field values from string to numbers, so that i can set up the dashboard as time series.
The Query type needs to be text, because there are mixed values from the JSON its pulling.

I know i can use the transformation “Convert field type” to change the fields to numbers, and it works. But the thing is there is alot of fields, and i want it to do it automatically. Is there any way to change the type of every field(except Time)?

what is your datasource? probably best to do it on datasource.

Datasource is Zabbix.
It needs to be sent as text from Zabbix, because of the mixed values. I was hoping it could be done in grafana, which it can but its manually work.

1 Like