Hi,

I see 2 possibility to solve your issue here :
- both value and counter column have to be filled with the appropriate data. ValueN= CounterN - Counter N-1 (be carefull on the unit, compare with my value bellow)
- In my case I have one row / day. Try to fill all days between first and last ...

So after a lot of test I finaly get the good setup.
I will paste here is it could help :

sqlquery look like this :
INSERT INTO `Meter_Calendar` VALUES ('ID of the device','consuption of the day','counter value','day');
INSERT INTO `Meter_Calendar` VALUES ('22','12.7','471.27','2015-01-01 ...

Hi, and thanks for this info.

this is what I have try.

I have first put daily data into meter_calendar but still not appear in the domoticz curve

Here my sql statment executed succesfully:

insert into meter_calendar values
(22, 12,0, "01/01/2015" ),
(22, 9,0, "02/01/2015" ),
(22, 22,0, "03 ...

Hi Jan_nl, All,

First post for me and it seams to this forum is well interesting.

I have just installed a domoticz db on a raspberry and and wantn now to put water consuption for the past days and month.
It is quite similar that your requets and I wonder if you success to update your db as ...