Strange Graphical Report

cdj
Topic Author
Offline
Elite Member

9 years 8 months ago - 9 years 8 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

Last edit: 9 years 8 months ago by cdj.

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

EasyIoT
Offline
Administrator

9 years 8 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.

cdj
Topic Author
Offline
Elite Member

9 years 8 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.

EasyIoT
Offline
Administrator

9 years 8 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.

cdj
Topic Author
Offline
Elite Member

9 years 8 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

Strange Graphical Report

Forum latest