Reading Temperature Values as table but not plotting it!

Grafana Configuration
1

I am really now to Grafana and would like to know what i am doing wrong here. I can read a query as table but can´t plot it as a graph as it says “No graphable fields”.

My query is:

SELECT
  reading_time AS "time",
  value1
FROM "SensorData"
WHERE
  $__timeFilter(reading_time)
ORDER BY 1

my table:

WhatsApp Image 2021-06-13 at 18.56.22
WhatsApp Image 2021-06-13 at 18.56.22981×308 26.1 KB

Can anyone explain me why i cant plot it?

Thnaks

1 Like
2

To fix this you have to add a group by time. Look at the following image:

image

1 Like
3

Hello, you were able to solve the problem I have the same problem ? :frowning:

4

You might need to convert your data. Look at the structure of your database to check the type of your value column. In my case, it was a varchar which is literally “not graphable” but looks fine in the table. Grouping is a workaround (although to be honest, I don’t know why that works) but in my case it was much simpler to convert on the fly. Using the OP example:

SELECT
  reading_time AS "time",
  CONVERT(value1, FLOAT)
FROM "SensorData"
WHERE
  $__timeFilter(reading_time)

Hope that helps a poor soul that wanders around the web trying to find out what is going on with his or her query…

5

I am experiencing the same problem.
I am taking the values from Influxdb. Not having specified any type of value by default Influx should save floats.
However, I can see the data in a table but I cannot plot them in a graph.
I am not sure how to sort this problem.
My query is rather simple:

SELECT “value” FROM “temperature” WHERE time >= now() - 3h and time <= now()

I need some help to fix this but I would love to understand why this is happening.
Thanks for helping

6

I am Visit at community

7

Upgraded to latest 8.1.1, I was on 8.0.1 working perfectly fine, now my simple query does not work but it did before, oh dear.

Any help, please?