Strange Graphical Report

6 years 10 months ago - 6 years 10 months ago #911 by cdj
Strange Graphical Report was created by cdj
Hello Folks,
finally from some days i've nodemcu sensors working....but something strange appear in graphics :



Scale seems to be strange, in temp there's 200 ....and then drop to 20 ???
That's ok that sometimes goes to 0 because in my lab sometimes wifi signal is not good or i reset sensors after some hang....
here is graphics :






and in particular in pressure if i click "week" in pressure:


What's wrong?

Thanks
Dario

Please Log in or Create an account to join the conversation.

6 years 10 months ago #920 by EasyIoT
Replied by EasyIoT on topic Strange Graphical Report
Last error usually happens if not all values in database are are numeric.
The following user(s) said Thank You: cdj

Please Log in or Create an account to join the conversation.

6 years 10 months ago #922 by cdj
Replied by cdj on topic Strange Graphical Report
Ok, to fix it i must drop db ? And for other graphs problems ? Some way to debug db, like phpmyadmin for mysql? Just to see values...
Thanks

Please Log in or Create an account to join the conversation.

6 years 10 months ago #923 by EasyIoT
Replied by EasyIoT on topic Strange Graphical Report

cdj wrote: Ok, to fix it i must drop db ? And for other graphs problems ? Some way to debug db, like phpmyadmin for mysql? Just to see values...
Thanks


use sqlitebrowser, DB file is EasyIoTDatabase.sqlite
The following user(s) said Thank You: cdj

Please Log in or Create an account to join the conversation.

6 years 10 months ago #928 by cdj
Replied by cdj on topic Strange Graphical Report
Ok values in db are strange, probably due to my automation script. In temp for example i have 205 and then 20.5. But also high value only as 206 and 207 (and then no 20.6 value)...

this is my run part of automation :
  //String response = QueryServer("GETTEMP");
  String temp = QueryServer("GETTEMP");
  float result = Convert.ToSingle(temp);
  float response = (result/10);
  Console.WriteLine(response);
  ModuleHelper.SetProperty("Virtual", NODE_ADDRESS, "Sensor.Temperature", response.ToString());
  EventHelper.SetEvent("Virtual", NODE_ADDRESS, "Sensor.Temperature");

I do the /10 here in atuomation script because i've seen that make operation in LUA file give instability
Exactely when is created database record? i suppose in setevent ?

What's wrong?
Tnx
Dario

Please Log in or Create an account to join the conversation.

6 years 9 months ago #962 by cdj
Replied by cdj on topic Strange Graphical Report
Please UP! Just to know if is setevent that write value in db, Hanks
Dario

Please Log in or Create an account to join the conversation.

Time to create page: 0.265 seconds

Forum latest

  • No posts to display.