Shouldnt that be DROP MEASUREMENT <measurement_name> temp in this case
I see .. my mistake.
Now that you dropped both .. do you still get errors in node red ? what does show field keys show ?
are both now float ?
and also in the query why you have selected 'numbers'. shouldnt that be 'value' ?
I still have errors in NR, but only for temp. I gave pic. for show field keys earlier today.
About value-number problem, wen we use value we got error in Grafana, now with number we don't have error (the error was: query.string interrupt iterator ) just we don't have data
I see the screenshot.
The screenshot showed earlier that the value for temp was string.
This is what is causing the error in node-red for temp.
It is still string even after you dropped both MEASUREMENTS ?
Yes, i think so (at least this i see from the error) .
I have said several times and now @UnborN has also pointed out that in the query you have asked for a field called numbers whereas the field is actually called value. There is no field called numbers in the database so there is no data to show on the chart. Do you understand what I am saying?
Yes, i think so. But how to fix it?
What do you think this means in the query config?
I'm not sure.
Could it possibly mean 'select the field called numbers'?
If you click on it then it should show the fields that exist in the database (but you already new that as you did it right near the start of the thread). For some reason you changed the selected field from value to numbers back in post 70 and I told you then that was not correct. You need to change it back.
I change it because i had errors. Now i return it, but grafana still says : No data
You changed it and I pointed out that was not the correct solution.
Again you don't provide the information needed. Post the screenshot of the grafana dashboard showing no data, the output from the query inspector and the full output from running influx to examine the database including USEing the database.
A question, why do you keep starting the influx service when you do that? Is it not running all the time?
Q Inspector
{
"request": {
"method": "GET",
"url": "api/datasources/proxy/1/query",
"params": {
"db": "HUMIDITY",
"q": "SELECT mean(\"value\") FROM \"humid\" 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(\"value\") FROM \"humid\" WHERE time >= 1597571341360ms and time <= 1597744141368ms GROUP BY time(2m) fill(null)"
}
}
I start influx only when i start the RPI
You are asking for data from 10 days ago, but you deleted all that when you dropped the measurement.
I received data ! Thank you for all your help and patience with me, i know it wasn't easy.
Can I suggest you go back to the start of the thread and spend some time working right through and making sure you understand everything. That way you should understand more about what went wrong.
Also, there is no need to start the service every time you open the terminal, it must be running already or grafana would not be able to get the data.
Finally, in case you did not realise you can also access node red on the pi from a browser running on the PC in the same way you are with grafana, simply by using :1880 instead of :3000 after the ip address of the pi.
I am going to close this thread as it has got much too long. If you have any more problems please start another thread and give it a title that matches the question.
1 Like
