I am new to Grafana and have a problem regarding the format of my sql table “value” column.
If it is possible I would like to convert the values “open” and “closed” to numeric values within Grafana. Unfortunately my knowledge in this area is very limited.
If anyone has a “CONVERT(” function at hand to do this I would appreciate the help.
Via google I have found options within node-red, but I would prefer a Grafana alternative.