Strange values graphical log view

[SunHopper]

My smart meter P1 graphic logging showing some strange behavior.
When the power in/out comes around 500Watt both in and out come together and showing both higher values than 0Watt.
When this happens looking at the received data in the devices section one of the IN/OUT values is always 0 as it should be.
Looking in the domoticz database the same. Always one value is 0!
Version 2024.7 running on Ubuntu in a VM

Why is this happening?

Schermafbeelding 2025-04-08 091004.png (159.46 KiB) Viewed 1561 times

[gizmocuz]

How come you have a SDM630 (as I do as well) in a P1 graph? You should have kWh devices (if you use my modbus python plugin)
So who is creating this P1 device? Did you had a look at that code?

[SunHopper]

@ gizmocuz I programmed a (my own arduino code) ESP8266 to convert the modbus protocol to a Json string and send it to Domoticz.
Have used this for a lot of years now but never seen this behavior of the graphical overview.
I think it happened after one of the last updates.

[SunHopper]

@mark81
I send a json update every 10 seconds. Did change te update frequency to 1 minute but no difference. Tried print values to the log in the script_device_power2p1.lua script. But putting a print(value) line after line 19 "if (devicechanged[GRID_DEV]~=nil) then" the output is no longer visible in the log of Domoticz. I'm 100% sure one of in/out is always 0

[SunHopper]

Here another example. Until 9.00 both in and out run parallel. Then in drops to 0 what it should be. It are not spikes as you can see.

IMG_1383.jpg (68.57 KiB) Viewed 1511 times

[waltervl]

If you download the csv file from the graph (from hamburger menu) do you see the same incorrect values as on the graph?
Also when using the API call (change IDX into valid value)?

Code: Select all

/json.htm?type=command&param=graph&sensor=counter&idx=IDX&range=day

[SunHopper]

The database belonging to the last screenshot

Schermafbeelding 2025-04-08 141353.png (37.54 KiB) Viewed 1507 times

[waltervl]

If you download the csv file from the graph (from hamburger menu) do you see the same incorrect values as on the graph?
Also when using the API call (change IDX into valid value)?

Code: Select all

/json.htm?type=command&param=graph&sensor=counter&idx=IDX&range=day

Repeat request...

[SunHopper]

Schermafbeelding 2025-04-08 142413.png (20.2 KiB) Viewed 1501 times

{
"d" : "2025-04-08 07:45",
"eg" : "448",
"eu" : "2568",
"r1" : "132",
"r2" : "0",
"v1" : "84",
"v2" : "0"
},
{
"d" : "2025-04-08 07:50",
"eg" : "452",
"eu" : "2571",
"r1" : "48",
"r2" : "0",
"v1" : "36",
"v2" : "0"
},
{
"d" : "2025-04-08 07:55",
"eg" : "456",
"eu" : "2573",
"r1" : "48",
"r2" : "0",
"v1" : "24",
"v2" : "0"
},
{
"d" : "2025-04-08 08:00",
"eg" : "462",
"eu" : "2579",
"r1" : "72",
"r2" : "0",
"v1" : "72",
"v2" : "0"
},
{
"d" : "2025-04-08 08:05",
"eg" : "471",
"eu" : "2588",
"r1" : "99",
"r2" : "0",
"v1" : "99",
"v2" : "0"
},
{
"d" : "2025-04-08 08:10",
"eg" : "487",
"eu" : "2604",
"r1" : "192",
"r2" : "0",
"v1" : "192",
"v2" : "0"
},
{
"d" : "2025-04-08 08:15",
"eg" : "507",
"eu" : "2623",
"r1" : "240",
"r2" : "0",
"v1" : "228",
"v2" : "0"
},
{
"d" : "2025-04-08 08:20",
"eg" : "532",
"eu" : "2649",
"r1" : "300",
"r2" : "0",
"v1" : "312",
"v2" : "0"
},
{
"d" : "2025-04-08 08:25",
"eg" : "561",
"eu" : "2679",
"r1" : "348",
"r2" : "0",
"v1" : "360",
"v2" : "0"
},
{
"d" : "2025-04-08 08:30",
"eg" : "597",
"eu" : "2713",
"r1" : "432",
"r2" : "0",
"v1" : "408",
"v2" : "0"
},
{
"d" : "2025-04-08 08:35",
"eg" : "638",
"eu" : "2753",
"r1" : "492",
"r2" : "0",
"v1" : "480",
"v2" : "0"
},
{
"d" : "2025-04-08 08:40",
"eg" : "685",
"eu" : "2799",
"r1" : "564",
"r2" : "0",
"v1" : "552",
"v2" : "0"
},
{
"d" : "2025-04-08 08:45",
"eg" : "737",
"eu" : "2852",
"r1" : "624",
"r2" : "0",
"v1" : "636",
"v2" : "0"
},
{
"d" : "2025-04-08 08:50",
"eg" : "797",
"eu" : "2911",
"r1" : "720",
"r2" : "0",
"v1" : "708",
"v2" : "0"
},
{
"d" : "2025-04-08 08:55",
"eg" : "862",
"eu" : "2975",
"r1" : "780",
"r2" : "0",
"v1" : "768",
"v2" : "0"
},
{
"d" : "2025-04-08 09:00",
"eg" : "934",
"eu" : "3048",
"r1" : "864",
"r2" : "0",
"v1" : "876",
"v2" : "0"
},
{
"d" : "2025-04-08 09:05",
"eg" : "1013",
"eu" : "3108",
"r1" : "948",
"r2" : "0",
"v1" : "720",
"v2" : "0"
},
{
"d" : "2025-04-08 09:10",
"eg" : "1100",
"eu" : "3111",
"r1" : "1044",
"r2" : "0",
"v1" : "36",
"v2" : "0"
},
{
"d" : "2025-04-08 09:15",
"eg" : "1198",
"eu" : "3111",
"r1" : "1176",
"r2" : "0",
"v1" : "0",
"v2" : "0"
},
{
"d" : "2025-04-08 09:20",
"eg" : "1311",
"eu" : "3111",
"r1" : "1356",
"r2" : "0",
"v1" : "0",
"v2" : "0"
},
{
"d" : "2025-04-08 09:25",
"eg" : "1440",
"eu" : "3111",
"r1" : "1548",
"r2" : "0",
"v1" : "0",
"v2" : "0"
},
{
"d" : "2025-04-08 09:30",
"eg" : "1580",
"eu" : "3111",
"r1" : "1680",
"r2" : "0",
"v1" : "0",
"v2" : "0"
},
{
"d" : "2025-04-08 09:35",
"eg" : "1732",
"eu" : "3111",
"r1" : "1824",
"r2" : "0",
"v1" : "0",
"v2" : "0"
},
{
"d" : "2025-04-08 09:40",
"eg" : "1898",
"eu" : "3111",
"r1" : "1992",
"r2" : "0",
"v1" : "0",
"v2" : "0"
},
{
"d" : "2025-04-08 09:45",
"eg" : "2075",
"eu" : "3111",
"r1" : "2124",
"r2" : "0",
"v1" : "0",
"v2" : "0"
},
{
"d" : "2025-04-08 09:50",
"eg" : "2260",
"eu" : "3111",
"r1" : "2220",
"r2" : "0",
"v1" : "0",
"v2" : "0"
},

[SunHopper]

These values are not the same as in the database ! Where are these values stored?

[waltervl]

These values are not the same as in the database ! Where are these values stored?

They are calculated by the Domoticz webui based on values from the database.....
Can you try this in an incignito/private browser session? Could be an issue with you cache....

[waltervl]

You can try to switch to simple P1 view (no T1 and T2) if you have no difference in T1/T2 tariffs. You can do this in menu Setup, Settings, tab Meter/Counters.

There seems to be an issue in the code here where the data is sent from database to graphing system: https://github.com/domoticz/domoticz/bl ... h.cpp#L405