Time Series Graph not accepting numeric casting

Grafana
, ,
1

Hello,
I’m currently trying to graph a dataset that is returned from an API and I’m running into issues where the the graph says “Data is missing a number field”. After looking at your documentation I came to the solution that I needed to cast the string into an Integer, but that doesn’t seem to be helping. Any ideas what I might be doing wrong would be helpful.

Data from the API:

[["10","2024-01-07"],["241","2024-01-08"],["288","2024-01-09"],["692","2024-01-10"],["286","2024-01-11"],["263","2024-01-12"],["11","2024-01-13"],["83","2024-01-15"],["220","2024-01-16"],["228","2024-01-17"],["170","2024-01-18"],["250","2024-01-19"],["11","2024-01-20"],["10","2024-01-21"],["70","2024-01-22"]]

Screen shot of the error:

image
image1894×828 55.2 KB

Screen shot of the table view:

image
image1900×878 68.8 KB

Screen shot of query browser:

image
image446×919 31 KB

2

"288" is a string, but 288 is a number → your API return strings instead of numbers, so they are not threated as numbers in the Grafana. You can see it in the table view as String icon in header:

image
image1115×235 24.7 KB

Override is how it is visualized - that’s not for casting.
Fix your API.
Or (the worse solution) use transformation on the Grafana level to convert string field to numeric field:

3

That’s not an error but that said what is the name of the first data set, what does it represent?