# NR+influxdb+grafana

**URL:** <https://discourse.nodered.org/t/nr-influxdb-grafana/31667>\
**Category:** General\
**Created:** [17 August 2020 16:43 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667 "2020-08-17T16:43:23Z")\
**Posts on this page:** 20\
**Page:** 4

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [25 August 2020 19:39 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/62 "2020-08-25T19:39:15Z")

</div>

Is the field you are trying to chart called field1 or value, and does it exist in the `temp` measurement? If you use the influx command line, USE the database HUMIDITY and then `select * from temp` you will see what data you have for each field.

Are you getting an error now or just no data?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [26 August 2020 10:35 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/63 "2020-08-26T10:35:13Z")

</div>

From influx command line i've got this:

 ![2020-08-23-163452_800x480_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/d/2d63580d1889ee52420ed7ad9a37f1fb318ebce3.png)

Yes, i still got this error:

```auto
InfluxDB Error: not executed

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [26 August 2020 11:06 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/64 "2020-08-26T11:06:49Z")

</div>

Can you show the influx command line output, including the full command sequence to get there please. I want to see the database selection and the headings. If you use `select * from temp order by time desc limit 5` then it will output just the most recent samples.  
Also in grafana click on the Query Inspector button at the right above the query definition and click Copy to Clipboard and then paste the result here. Use the `</>` button when pasting it in. Click Query Inspector again to make it go away.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [26 August 2020 13:52 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/65 "2020-08-26T13:52:45Z")

</div>

![2020-08-26-164117_800x480_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/5/b52407b245ba751334c0e62a0f9f186f9d1891e8.png)

```auto
{
  "request": {
    "method": "GET",
    "url": "api/datasources/proxy/1/query",
    "params": {
      "db": "HUMIDITY",
      "q": "SELECT mean(\"value\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null);SELECT mean(\"value\") FROM \"measurement\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)",
      "epoch": "ms"
    },
    "data": null,
    "precision": "ms"
  },
  "response": {
    "results": [
      {
        "statement_id": 0,
        "error": "not executed"
      }
    ],
    "executedQueryString": "SELECT mean(\"value\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null);SELECT mean(\"value\") FROM \"measurement\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)"
  }
}

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [26 August 2020 14:01 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/66 "2020-08-26T14:01:05Z")

</div>

Look carefully at the queries shown in the query inspector. What do you see that is unexpected? Check the full text of the query.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [26 August 2020 14:10 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/67 "2020-08-26T14:10:19Z")

</div>

I can't understand what is going on

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [26 August 2020 14:13 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/68 "2020-08-26T14:13:15Z")

</div>

You have not answered the question. There appear to be two queries in the query inspector, one fetching the field value from the measurement temp and a second one fetching the field value from the measurement named measurement. However there is no such measurement in the database. It suggests to me that you have defined two queries for that chart, but have only been showing us the first one.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [26 August 2020 14:40 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/69 "2020-08-26T14:40:16Z")

</div>

Yes, they was second queries, but i was forget about it (sorry).I delete it, but the problem remains (but a little different).

 ![Query inspector 2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/b/9be431ef687a05e56c2d8f63c9f80f8241b8cdc5.jpeg)

This is the new query inspector:

```auto
{
  "request": {
    "method": "GET",
    "url": "api/datasources/proxy/1/query",
    "params": {
      "db": "HUMIDITY",
      "q": "SELECT mean(\"value\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)",
      "epoch": "ms"
    },
    "data": null,
    "precision": "ms"
  },
  "response": {
    "results": [
      {
        "statement_id": 0,
        "error": "unsupported mean iterator type: *query.stringInterruptIterator"
      }
    ],
    "executedQueryString": "SELECT mean(\"value\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)"
  }
}

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [26 August 2020 15:51 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/70 "2020-08-26T15:51:55Z")

</div>

Have you written strings to the `value` field instead of numbers? If you want to chart them then they must be numbers.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [26 August 2020 16:19 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/71 "2020-08-26T16:19:50Z")

</div>

Like This?

 ![Grafana Field](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/9/79427dc108a020beca5f88bc35ab155500c484d5.jpeg)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [26 August 2020 16:20 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/72 "2020-08-26T16:20:51Z")

</div>

No, where you write to the database (in node red presumably). I suspect that you have written strings instead of numbers.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [26 August 2020 17:01 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/73 "2020-08-26T17:01:11Z")

</div>

Actually it did do the trick, now i don't have errors, but still can't collect data.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [26 August 2020 17:17 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/74 "2020-08-26T17:17:49Z")

</div>

Make sure you zoom out in case the data is outside the time range.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [26 August 2020 17:26 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/75 "2020-08-26T17:26:12Z")

</div>

I try, but It says no data

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [26 August 2020 17:47 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/76 "2020-08-26T17:47:53Z")

</div>

What does the data in the dB look like now?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [26 August 2020 18:01 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/77 "2020-08-26T18:01:42Z")

</div>

```auto
1598460336473640187 27.00
1598460340183409036 28.00
1598461598993604339 28.00
> 

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [26 August 2020 19:22 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/78 "2020-08-26T19:22:33Z")

</div>

And the dashboard showing no data?  
Also the query inspector output

**[Edit]** Also please show the commands you used to show the data, as you did before.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [27 August 2020 10:21 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/79 "2020-08-27T10:21:46Z")

</div>

I don't have data anywhere.

Which commands for data you want, from Influxdb or Grafana? From Influxdb are the same.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [27 August 2020 10:40 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/80 "2020-08-27T10:40:26Z")

</div>

Show me the query inspector output, a screenshot of the chart showing no data and the terminal commands running influx, USEing the database and SELECTING the data to show what is in the database please.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [27 August 2020 13:45 UTC](https://discourse.nodered.org/t/nr-influxdb-grafana/31667/81 "2020-08-27T13:45:28Z")

</div>

Query inspector

```auto
{
  "request": {
    "method": "GET",
    "url": "api/datasources/proxy/1/query",
    "params": {
      "db": "HUMIDITY",
      "q": "SELECT mean(\"numbers\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)",
      "epoch": "ms"
    },
    "data": null,
    "precision": "ms"
  },
  "response": {
    "results": [
      {
        "statement_id": 0
      }
    ],
    "executedQueryString": "SELECT mean(\"numbers\") FROM \"temp\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)"
  }
}

```

Grafana Chart

 ![Grafana Chart](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/e/5e10d3fa12f72efdb11bcec917e4f77055bcc607.jpeg)

InfluxDB command

 ![2020-08-27-164241_800x480_scrot](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/f/cf31ec078b73dc4e2feb076ae0b0a9444992c23d.png)

[Previous page](https://discourse.nodered.org/t/nr-influxdb-grafana/31667.md?page=3)

[Next page](https://discourse.nodered.org/t/nr-influxdb-grafana/31667.md?page=5)