Convert JSON String to Number

I have set up a panel that gets data from my smart meter via rest API. This works fine, however I can only show the data in a table view as Grafana is unable to graph the data. Does this have something to do with the returned JSON values actually being strings even though they display as numbers? If this is the case, is it possible to convert the strings to actual numbers so I can display the numbers in a bar chart?

image

Any help or pointers would be really appreciated.

Rob

Solved it myself. It helps if you can read. I changed the field type from string to number and now the date is showing up in a bar chart. Love Grafana.

Rob

1 Like