Grafana can't read the data from Influxdb

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

Here can I read the data using python.

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

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.