search

jorgebooks / measureit

Automatically exported from code.google.com/p/measureit
0 stars 0 forks source link

Calculation on start page is wrong #49

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Why the graph of current has the waveform sawtooth?
There are many values ​​to zero, and should be similar to the waveform of 
preview which is located at the bottom.

What steps will reproduce the problem?
1. Acquire values ​​equal to zero, at regular intervals.
2. Display the graph

What is the expected output? What do you see instead?
A square waveform in the graph, like the preview.

What version of the product are you using? On what operating system?
Version 115. Raspberry Wheezy.

Original issue reported on code.google.com by fabrizio...@gmail.com on 10 Dec 2013 at 7:54

Attachments:

GoogleCodeExporter commented 9 years ago 
I have made the same graph. A addition of my investigation:
also the calculation of power consumtion goes wrong. 

I have a summary counter for the whole house and two transmitter behind of them 
to count the consumation of a heat pump an a boiler. But the summary of the 
both transmitter is higher than the whole house.

Also i my office, i have two IAM's in a row. First for count the whole office, 
the second for counting the consumption of a oil  heater.

Every device, that have a consumption like on/off, could not correct detected. 
Some zero values are not correct counted. Like boiler or the oilheater.

Every device, the have everytime a small consumption, can count correct, 
because they go never to zero. Like my heat pump with their microprocessor or 
my office with some ever running devices.

Now, at the calculation of consumption, the sawtooth graph get the wrong(to 
high) values.

I hope, that i have to give a hint to clarifying the problem. Look on my 
pictures.

Regards
Tom

Original comment by tma4...@gmail.com on 14 Dec 2013 at 6:53

Attachments:

GoogleCodeExporter commented 9 years ago 
Hello Tom and thanks for the reply.
I do not know to tell you because in your case the sum gives a wrong result.
But I think the sawtooth wave is only a problem of graphic representation and 
not the data, because I tried to read the data in the database.
In the example below, there are no data from 10:08 to 11:08 and from 11:18 to 
12:19.

=======================

mysql> select * from measure_watt where time like "2013-12-19 10%";
+---------+--------+------+---------------------+
| watt_id | sensor | data | time                |
+---------+--------+------+---------------------+
|   11328 |      0 |  106 | 2013-12-19 10:00:01 |
|   11329 |      0 |   98 | 2013-12-19 10:01:40 |
|   11330 |      0 |  104 | 2013-12-19 10:02:18 |
....................
|   11341 |      0 |   36 | 2013-12-19 10:08:10 |
|   11342 |      0 |   34 | 2013-12-19 10:08:15 |
|   11343 |      0 |   32 | 2013-12-19 10:08:21 |
|   11344 |      0 |    0 | 2013-12-19 10:08:32 |
+---------+--------+------+---------------------+
17 rows in set (0.07 sec)

mysql> select * from measure_watt where time like "2013-12-19 11%";
+---------+--------+------+---------------------+
| watt_id | sensor | data | time                |
+---------+--------+------+---------------------+
|   11345 |      0 |  118 | 2013-12-19 11:08:03 |
|   11346 |      0 |  117 | 2013-12-19 11:08:30 |
|   11347 |      0 |  108 | 2013-12-19 11:10:25 |
....................
|   11362 |      0 |   36 | 2013-12-19 11:18:33 |
|   11363 |      0 |   34 | 2013-12-19 11:18:39 |
|   11364 |      0 |   30 | 2013-12-19 11:18:50 |
|   11365 |      0 |    0 | 2013-12-19 11:18:55 |
+---------+--------+------+---------------------+
21 rows in set (0.06 sec)

mysql> select * from measure_watt where time like "2013-12-19 12%";
+---------+--------+------+---------------------+
| watt_id | sensor | data | time                |
+---------+--------+------+---------------------+
|   11366 |      0 |   85 | 2013-12-19 12:19:41 |
|   11367 |      0 |  108 | 2013-12-19 12:21:47 |
|   11368 |      0 |   98 | 2013-12-19 12:22:20 |
|   11369 |      0 |  104 | 2013-12-19 12:22:58 |
|   11370 |      0 |   98 | 2013-12-19 12:24:37 |
.........................

Original comment by fabrizio...@gmail.com on 19 Dec 2013 at 9:45

Attachments:

GoogleCodeExporter commented 9 years ago 
If I enable the display of points, it is seen that data is missing. How to draw 
the graph correctly?

Original comment by fabrizio...@gmail.com on 20 Dec 2013 at 12:11

Attachments:

GoogleCodeExporter commented 9 years ago 
Hi Fabrizio, Hi Tom,

the "missing" data is correct. Measureit dies not store multiple values of the 
same result. So if you have a usage from 0 about 5 minutes measureit stores 
only 1 time the usage instead of 897 times the usage from 0.

5min / 0 = 0
5min / (0+0+0+0+0+0.......) = 0

This is to keep the database small and fast. The effect in the graphs is the 
sawtooth. To get a "nice" graph measureit had to store all of the 0 values. 

If you really want to save all data you can take a look at this post.
https://code.google.com/p/measureit/issues/detail?id=39

Original comment by lalelu...@gmail.com on 26 Dec 2013 at 11:36

GoogleCodeExporter commented 9 years ago 
Hy Tom,

you are right. The display from the summary usage is wrong. I had to do some 
debugging....

Original comment by lalelu...@gmail.com on 26 Dec 2013 at 11:41

GoogleCodeExporter commented 9 years ago 
To store the same watt values multiple times see:
https://code.google.com/p/measureit/issues/detail?id=39

Original comment by lalelu...@gmail.com on 24 May 2014 at 12:16

GoogleCodeExporter commented 9 years ago

Original comment by lalelu...@gmail.com on 24 May 2014 at 12:17

GoogleCodeExporter commented 9 years ago 
Moved to github
https://github.com/lalelunet/measureit/issues/4

Original comment by lalelu...@gmail.com on 25 Jul 2014 at 8:21