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)?