Grafana can't read the data from Influxdb

Grafana InfluxDB
1

Hello,

I’m trying to use Grafana/InfluxDB to read the temperature and humidity in my room.

For some reason Grafana can’t read the data from InfluxDB even though that Grafana is being able to access the database and read the “Table” and I can read the data using another method.

Here you can see that Grafana has been able to read the “Table” rpi-dht22

image
image1263×252 22.6 KB

Here can I read the data using python.

image
image1365×1251 262 KB

Query:

{
  "request": {
    "method": "GET",
    "url": "api/datasources/proxy/2/query",
    "params": {
      "db": "sensor_data",
      "q": "SELECT mean(\"temperature\") FROM \"rpi-dht22\" WHERE time >= now() - 5m and time <= now() GROUP BY time(200ms) fill(none)",
      "epoch": "ms"
    },
    "data": null,
    "precision": "ms",
    "hideFromInspector": false
  },
  "response": {
    "results": [
      {
        "statement_id": 0
      }
    ],
    "executedQueryString": "SELECT mean(\"temperature\") FROM \"rpi-dht22\" WHERE time >= now() - 5m and time <= now() GROUP BY time(200ms) fill(none)"
  }
}

What am I missing?

Thanks in advance

2

What’s the actual result/message/error you’re getting?

Also do you definitely have data for the last 5 minutes? The query you’re running in Grafana is clearly very different from the one you’re running in Python. If you really want to troubleshoot, it would be worth running the same query in both.