Grafana shows error when using spaces in coloum names

[me310]

Using Hosted Grafana, i want to show a simple time series graph.
Here is my sql database.

So far so good: (cant upload more than 2 pictures in one post, but believe me, it works ^^)

As soon as i put spaces in the coloum names (e.g. “product1M” → “product 1 M”) (in Grafana and the correspoonding data source of course), Grafana shows an error(‘Data is missing a number field’)

How can i fix this?

[mattabrams]

can you screenshot your data in table mode? Or use the inspect feature to share your raw query request and response?

[dabturn]

It would be great if @me310 updated this thread with the resolution. Great question, curious about the answer.