Usage data last month and last year not displaying anything

Moderator: leecollings

jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Usage data last month and last year not displaying anything

Post by jacobh »

I'm using Domoticz beta 2024.7 (build 16325). My Log-view panels for power do display the usage data "usage last three days" and "usage last week", as well as for the "comparing usage", but I'm getting a "no data to display" on the panels "usage last month" and "usage last year".
What is wrong here and how to fix?
Same panels under my gas utility show proper data in the matching panels
gas_domoticz.jpg
gas_domoticz.jpg (123.96 KiB) Viewed 1632 times
power_domoticz.jpg
power_domoticz.jpg (95.53 KiB) Viewed 1632 times
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

Do a ctrl-F5 to force a refresh of the browser javascripts or use a browser session in incognito/private mode.
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Re: Usage data last month and last year not displaying anything

Post by jacobh »

Thanks, tried the CTRL+F5 and incognito browser. No effect, still same two panes showing "no data available".
Also tried other browsers, same picture. I reckon the data would be stored in the domoticz.db. In what table are they stored? Can I check there for more detail?
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

That data is probably in meter_calendar or multimeter_calendar table.
That data is there as the compare graph shows data of last month.
Do you see proper data in the report page (report button top right)?
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Re: Usage data last month and last year not displaying anything

Post by jacobh »

Ok, just checked if there was any data in the report page. Exported the csv's of the missing panels. They only show a header line, no actual data there.
Did the same thing for Gas, they do show data.
Now went to the database and looked at the tables you mentioned. My Power utility has DeviceId 21, for Gas this is 25.
In the Meter_Calendar I find 2838 entries for id 25 (oldest 2020-09-01, most recent 2024-11-05). I don't find any entries for Id 21.
In the Multimeter_Calendar I find 0 entries for id 25, 1404 entries for id 21 (oldest 2020-09-01, most recent 2024-11-05).
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

So the data is in the database. It is OK to have it in 2 different tables.
Then we have 1 last test to do, get the month data through the API for bothe IDX device 21 and 25 (change IDX, IP and port in link below)

Code: Select all

http://YourIP:port/json.htm?type=command&param=graph&sensor=counter&idx=IDX&range=month
It should give a list of values with data per day of last month.
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

Additional: as I see a last week graph in your 2024.7 screenshot it indicates to me it is a browser cache issue as that graph is deleted in 2024.7!!!

Do not switch in the same browser session from your old to new environment!! There should only be a last month graph with a 1 wk filter:
Screenshot_20241107-074742.png
Screenshot_20241107-074742.png (167.61 KiB) Viewed 1587 times
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Re: Usage data last month and last year not displaying anything

Post by jacobh »

{
"CostEnergy" : 2149,
"CostEnergyR1" : 800,
"CostEnergyR2" : 800,
"CostEnergyT2" : 2149,
"CostGas" : 6218,
"CostWater" : 16473,
"Divider" : 1000.0,
"DividerEnergy" : 1000.0,
"DividerWater" : 100.0,
"P1_Tariff" : "High",
"ValueQuantity" : "",
"ValueUnits" : "",
"counter" : "5247.769",
"result" :
[
{
"c" : "5179.35",
"d" : "2024-10-07",
"p" : "0.0000",
"v" : "1.57"
},
{
"c" : "5180.92",
"d" : "2024-10-08",
"p" : "0.0000",
"v" : "0.48"
},
{
"c" : "5181.40",
"d" : "2024-10-09",
"p" : "0.0000",
"v" : "0.60"
},
{
"c" : "5182.00",
"d" : "2024-10-10",
"p" : "0.0000",
"v" : "1.34"
},
{
"c" : "5183.34",
"d" : "2024-10-11",
"p" : "0.0000",
"v" : "2.18"
},
{
"c" : "5185.52",
"d" : "2024-10-12",
"p" : "0.0000",
"v" : "4.42"
},
{
"c" : "5189.93",
"d" : "2024-10-13",
"p" : "0.0000",
"v" : "1.73"
},
{
"c" : "5191.66",
"d" : "2024-10-14",
"p" : "0.0000",
"v" : "2.93"
},
{
"c" : "5194.59",
"d" : "2024-10-15",
"p" : "0.0000",
"v" : "3.04"
},
{
"c" : "5197.64",
"d" : "2024-10-16",
"p" : "0.0000",
"v" : "3.15"
},
{
"c" : "5200.78",
"d" : "2024-10-17",
"p" : "0.0000",
"v" : "1.69"
},
{
"c" : "5202.48",
"d" : "2024-10-18",
"p" : "0.0000",
"v" : "0.76"
},
{
"c" : "5203.24",
"d" : "2024-10-19",
"p" : "0.0000",
"v" : "0.98"
},
{
"c" : "5204.22",
"d" : "2024-10-20",
"p" : "0.0000",
"v" : "1.39"
},
{
"c" : "5205.60",
"d" : "2024-10-21",
"p" : "0.0000",
"v" : "1.74"
},
{
"c" : "5207.35",
"d" : "2024-10-22",
"p" : "0.0000",
"v" : "1.07"
},
{
"c" : "5208.42",
"d" : "2024-10-23",
"p" : "0.0000",
"v" : "1.67"
},
{
"c" : "5210.08",
"d" : "2024-10-24",
"p" : "0.0000",
"v" : "1.66"
},
{
"c" : "5211.75",
"d" : "2024-10-25",
"p" : "0.0000",
"v" : "2.08"
},
{
"c" : "5213.83",
"d" : "2024-10-26",
"p" : "0.0000",
"v" : "1.31"
},
{
"c" : "5215.14",
"d" : "2024-10-27",
"p" : "0.0000",
"v" : "0.60"
},
{
"c" : "5215.74",
"d" : "2024-10-28",
"p" : "0.0000",
"v" : "3.16"
},
{
"c" : "5218.90",
"d" : "2024-10-29",
"p" : "0.0000",
"v" : "1.45"
},
{
"c" : "5220.35",
"d" : "2024-10-30",
"p" : "0.0000",
"v" : "2.00"
},
{
"c" : "5222.35",
"d" : "2024-10-31",
"p" : "0.0000",
"v" : "1.42"
},
{
"c" : "5223.77",
"d" : "2024-11-01",
"p" : "0.0000",
"v" : "2.42"
},
{
"c" : "5226.19",
"d" : "2024-11-02",
"p" : "0.0000",
"v" : "2.72"
},
{
"c" : "5228.92",
"d" : "2024-11-03",
"p" : "0.0000",
"v" : "4.03"
},
{
"c" : "5232.95",
"d" : "2024-11-04",
"p" : "0.0000",
"v" : "4.71"
},
{
"c" : "5237.66",
"d" : "2024-11-05",
"p" : "0.0000",
"v" : "3.44"
},
{
"c" : "5241.10",
"d" : "2024-11-06",
"p" : "0.0000",
"v" : "4.81"
},
{
"c" : "5245.90",
"d" : "2024-11-07",
"p" : "0.0000",
"v" : "1.87"
}
],
"resultprev" :
[
{
"d" : "2023-10-07",
"p" : "0.0000",
"v" : "0.21"
},
{
"d" : "2023-10-08",
"p" : "0.0000",
"v" : "0.64"
},
{
"d" : "2023-10-09",
"p" : "0.0000",
"v" : "1.61"
},
{
"d" : "2023-10-10",
"p" : "0.0000",
"v" : "1.26"
},
{
"d" : "2023-10-11",
"p" : "0.0000",
"v" : "0.14"
},
{
"d" : "2023-10-12",
"p" : "0.0000",
"v" : "1.18"
},
{
"d" : "2023-10-13",
"p" : "0.0000",
"v" : "2.37"
},
{
"d" : "2023-10-14",
"p" : "0.0000",
"v" : "1.74"
},
{
"d" : "2023-10-15",
"p" : "0.0000",
"v" : "3.02"
},
{
"d" : "2023-10-16",
"p" : "0.0000",
"v" : "2.76"
},
{
"d" : "2023-10-17",
"p" : "0.0000",
"v" : "2.41"
},
{
"d" : "2023-10-18",
"p" : "0.0000",
"v" : "4.89"
},
{
"d" : "2023-10-19",
"p" : "0.0000",
"v" : "4.62"
},
{
"d" : "2023-10-20",
"p" : "0.0000",
"v" : "4.57"
},
{
"d" : "2023-10-21",
"p" : "0.0000",
"v" : "3.71"
},
{
"d" : "2023-10-22",
"p" : "0.0000",
"v" : "1.66"
},
{
"d" : "2023-10-23",
"p" : "0.0000",
"v" : "4.02"
},
{
"d" : "2023-10-24",
"p" : "0.0000",
"v" : "3.53"
},
{
"d" : "2023-10-25",
"p" : "0.0000",
"v" : "4.28"
},
{
"d" : "2023-10-26",
"p" : "0.0000",
"v" : "3.02"
},
{
"d" : "2023-10-27",
"p" : "0.0000",
"v" : "4.00"
},
{
"d" : "2023-10-28",
"p" : "0.0000",
"v" : "2.78"
},
{
"d" : "2023-10-29",
"p" : "0.0000",
"v" : "2.23"
},
{
"d" : "2023-10-30",
"p" : "0.0000",
"v" : "3.23"
},
{
"d" : "2023-10-31",
"p" : "0.0000",
"v" : "3.25"
},
{
"d" : "2023-11-01",
"p" : "0.0000",
"v" : "2.73"
},
{
"d" : "2023-11-02",
"p" : "0.0000",
"v" : "3.85"
},
{
"d" : "2023-11-03",
"p" : "0.0000",
"v" : "3.17"
},
{
"d" : "2023-11-04",
"p" : "0.0000",
"v" : "3.63"
},
{
"d" : "2023-11-05",
"p" : "0.0000",
"v" : "5.04"
},
{
"d" : "2023-11-06",
"p" : "0.0000",
"v" : "3.93"
},
{
"d" : "2023-11-07",
"p" : "0.0000",
"v" : "2.69"
}
],
"status" : "OK",
"title" : "Graph counter month"
}

{
"CostEnergy" : 2149,
"CostEnergyR1" : 800,
"CostEnergyR2" : 800,
"CostEnergyT2" : 2149,
"CostGas" : 6218,
"CostWater" : 16473,
"CounterR1" : "0.000",
"CounterR2" : "0.000",
"CounterT1" : "6869.547",
"CounterT2" : "8513.295",
"Divider" : 1000.0,
"DividerEnergy" : 1000.0,
"DividerWater" : 100.0,
"P1DisplayType" : 0,
"P1_Tariff" : "High",
"ValueQuantity" : "",
"ValueUnits" : "",
"result" :
[
{
"c1" : "6755.156",
"c2" : "0",
"c3" : "8366.837",
"c4" : "0",
"d" : "2024-10-07",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.913",
"v2" : "5.856"
},
{
"c1" : "6757.069",
"c2" : "0",
"c3" : "8372.693",
"c4" : "0",
"d" : "2024-10-08",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.589",
"v2" : "6.033"
},
{
"c1" : "6758.658",
"c2" : "0",
"c3" : "8378.726",
"c4" : "0",
"d" : "2024-10-09",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.850",
"v2" : "7.862"
},
{
"c1" : "6760.508",
"c2" : "0",
"c3" : "8386.588",
"c4" : "0",
"d" : "2024-10-10",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.756",
"v2" : "4.237"
},
{
"c1" : "6762.264",
"c2" : "0",
"c3" : "8390.825",
"c4" : "0",
"d" : "2024-10-11",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.188",
"v2" : "6.550"
},
{
"c1" : "6764.452",
"c2" : "0",
"c3" : "8397.375",
"c4" : "0",
"d" : "2024-10-12",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "6.622",
"v2" : "0.000"
},
{
"c1" : "6771.074",
"c2" : "0",
"c3" : "8397.375",
"c4" : "0",
"d" : "2024-10-13",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "7.839",
"v2" : "0.000"
},
{
"c1" : "6778.913",
"c2" : "0",
"c3" : "8397.375",
"c4" : "0",
"d" : "2024-10-14",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.113",
"v2" : "6.283"
},
{
"c1" : "6781.026",
"c2" : "0",
"c3" : "8403.658",
"c4" : "0",
"d" : "2024-10-15",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.387",
"v2" : "9.144"
},
{
"c1" : "6783.413",
"c2" : "0",
"c3" : "8412.802",
"c4" : "0",
"d" : "2024-10-16",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.114",
"v2" : "7.700"
},
{
"c1" : "6785.527",
"c2" : "0",
"c3" : "8420.502",
"c4" : "0",
"d" : "2024-10-17",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.988",
"v2" : "6.539"
},
{
"c1" : "6787.515",
"c2" : "0",
"c3" : "8427.041",
"c4" : "0",
"d" : "2024-10-18",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.829",
"v2" : "5.497"
},
{
"c1" : "6790.344",
"c2" : "0",
"c3" : "8432.538",
"c4" : "0",
"d" : "2024-10-19",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "7.502",
"v2" : "0.000"
},
{
"c1" : "6797.846",
"c2" : "0",
"c3" : "8432.538",
"c4" : "0",
"d" : "2024-10-20",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "6.701",
"v2" : "0.000"
},
{
"c1" : "6804.547",
"c2" : "0",
"c3" : "8432.538",
"c4" : "0",
"d" : "2024-10-21",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.833",
"v2" : "6.419"
},
{
"c1" : "6806.380",
"c2" : "0",
"c3" : "8438.957",
"c4" : "0",
"d" : "2024-10-22",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.091",
"v2" : "4.988"
},
{
"c1" : "6808.471",
"c2" : "0",
"c3" : "8443.945",
"c4" : "0",
"d" : "2024-10-23",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.099",
"v2" : "6.098"
},
{
"c1" : "6810.570",
"c2" : "0",
"c3" : "8450.043",
"c4" : "0",
"d" : "2024-10-24",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.878",
"v2" : "6.887"
},
{
"c1" : "6812.448",
"c2" : "0",
"c3" : "8456.930",
"c4" : "0",
"d" : "2024-10-25",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.598",
"v2" : "6.237"
},
{
"c1" : "6815.046",
"c2" : "0",
"c3" : "8463.167",
"c4" : "0",
"d" : "2024-10-26",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "9.913",
"v2" : "0.000"
},
{
"c1" : "6824.959",
"c2" : "0",
"c3" : "8463.167",
"c4" : "0",
"d" : "2024-10-27",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "9.228",
"v2" : "0.000"
},
{
"c1" : "6834.187",
"c2" : "0",
"c3" : "8463.167",
"c4" : "0",
"d" : "2024-10-28",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.158",
"v2" : "5.556"
},
{
"c1" : "6836.345",
"c2" : "0",
"c3" : "8468.723",
"c4" : "0",
"d" : "2024-10-29",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.186",
"v2" : "6.633"
},
{
"c1" : "6838.531",
"c2" : "0",
"c3" : "8475.356",
"c4" : "0",
"d" : "2024-10-30",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.087",
"v2" : "6.668"
},
{
"c1" : "6840.618",
"c2" : "0",
"c3" : "8482.024",
"c4" : "0",
"d" : "2024-10-31",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "4.081",
"v2" : "7.060"
},
{
"c1" : "6844.699",
"c2" : "0",
"c3" : "8489.084",
"c4" : "0",
"d" : "2024-11-01",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.611",
"v2" : "6.408"
},
{
"c1" : "6846.310",
"c2" : "0",
"c3" : "8495.492",
"c4" : "0",
"d" : "2024-11-02",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "6.959",
"v2" : "0.000"
},
{
"c1" : "6853.269",
"c2" : "0",
"c3" : "8495.492",
"c4" : "0",
"d" : "2024-11-03",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "8.950",
"v2" : "0.000"
},
{
"c1" : "6862.219",
"c2" : "0",
"c3" : "8495.492",
"c4" : "0",
"d" : "2024-11-04",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.988",
"v2" : "7.157"
},
{
"c1" : "6864.207",
"c2" : "0",
"c3" : "8502.649",
"c4" : "0",
"d" : "2024-11-05",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.782",
"v2" : "4.012"
},
{
"c1" : "6865.989",
"c2" : "0",
"c3" : "8506.661",
"c4" : "0",
"d" : "2024-11-06",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.770",
"v2" : "6.042"
},
{
"c1" : "6867.759",
"c2" : "0",
"c3" : "8512.703",
"c4" : "0",
"d" : "2024-11-07",
"p" : "0.0000",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.788",
"v2" : "0.577"
}
],
"resultprev" :
[
{
"d" : "2023-10-07",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "4.876",
"v2" : "0.000"
},
{
"d" : "2023-10-08",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "6.577",
"v2" : "0.000"
},
{
"d" : "2023-10-09",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.525",
"v2" : "4.323"
},
{
"d" : "2023-10-10",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.567",
"v2" : "4.258"
},
{
"d" : "2023-10-11",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.238",
"v2" : "4.152"
},
{
"d" : "2023-10-12",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.054",
"v2" : "4.905"
},
{
"d" : "2023-10-13",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.960",
"v2" : "5.450"
},
{
"d" : "2023-10-14",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "7.426",
"v2" : "0.000"
},
{
"d" : "2023-10-15",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "6.231",
"v2" : "0.000"
},
{
"d" : "2023-10-16",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.399",
"v2" : "5.603"
},
{
"d" : "2023-10-17",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.200",
"v2" : "4.241"
},
{
"d" : "2023-10-18",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.408",
"v2" : "4.916"
},
{
"d" : "2023-10-19",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.584",
"v2" : "5.410"
},
{
"d" : "2023-10-20",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.255",
"v2" : "6.926"
},
{
"d" : "2023-10-21",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "7.270",
"v2" : "0.000"
},
{
"d" : "2023-10-22",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "6.807",
"v2" : "0.000"
},
{
"d" : "2023-10-23",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.524",
"v2" : "5.021"
},
{
"d" : "2023-10-24",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.038",
"v2" : "5.096"
},
{
"d" : "2023-10-25",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.362",
"v2" : "4.467"
},
{
"d" : "2023-10-26",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.301",
"v2" : "5.104"
},
{
"d" : "2023-10-27",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.202",
"v2" : "5.828"
},
{
"d" : "2023-10-28",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "4.917",
"v2" : "0.000"
},
{
"d" : "2023-10-29",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "6.681",
"v2" : "0.000"
},
{
"d" : "2023-10-30",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.473",
"v2" : "3.923"
},
{
"d" : "2023-10-31",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.622",
"v2" : "4.197"
},
{
"d" : "2023-11-01",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.254",
"v2" : "4.164"
},
{
"d" : "2023-11-02",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "2.686",
"v2" : "4.882"
},
{
"d" : "2023-11-03",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.512",
"v2" : "7.575"
},
{
"d" : "2023-11-04",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "7.520",
"v2" : "0.000"
},
{
"d" : "2023-11-05",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "6.854",
"v2" : "0.000"
},
{
"d" : "2023-11-06",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.388",
"v2" : "5.315"
},
{
"d" : "2023-11-07",
"r1" : "0.000",
"r2" : "0.000",
"v1" : "1.367",
"v2" : "4.991"
}
],
"status" : "OK",
"title" : "Graph counter month"
}
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

waltervl wrote: Thursday 07 November 2024 7:50 Additional: as I see a last week graph in your 2024.7 screenshot it indicates to me it is a browser cache issue as that graph is deleted in 2024.7!!!

Do not switch in the same browser session from your old to new environment!! There should only be a last month graph with a 1 wk filter:
Screenshot_20241107-074742.png
Perhaps you missed this?
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Re: Usage data last month and last year not displaying anything

Post by jacobh »

Thanks for the reminder. Didn't miss it. Checked my browser settings (reckoning this is what you meant) and deleted complete cache.
Also tried changing Domoticz to stable version. No difference visible. :(
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

Delete more browser cache (google how to do it with your browser)
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Re: Usage data last month and last year not displaying anything

Post by jacobh »

I deleted ALL browser cache, cookies, etc now. Still two empty panes showing no data available in the Power log screen.
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

Perhaps something wrong with your update (eg not all files copied) because you should not see a week graph anymore.
run in a command line terminal:

Code: Select all

cd domoticz
sudo ./updatebeta
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Re: Usage data last month and last year not displaying anything

Post by jacobh »

I'm actually running Domoticz from a docker container, not sure how to implement these commands?
And wouldn't I initiate an upgrade to latest beta-version iso stable?
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

For docker according: https://hub.docker.com/r/domoticz/domoticz and you use docker compose, it will be something like

Code: Select all

docker compose pull && docker compose up --force-recreate --build -d && docker image prune -f
The version is set in your docker compose configuration:
image: domoticz/domoticz:beta(will pull latest beta version)
image: domoticz/domoticz:stable(will pull latest stable version)
image: domoticz/domoticz:2024.2(will pull latest stable version 2024.2)
image: domoticz/domoticz:2024-beta.12345(will pull beta with build number 12345)

Edit: also check the following file in your Domoticz environment: <yourDomoticzInstallFolder>/www/app/log/CounterLog.html
There should be no week chart entry in that file.

Normally thinking it can only be a browser cache issue....
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Re: Usage data last month and last year not displaying anything

Post by jacobh »

I've stated the following in my docker compose yml:
image: domoticz/domoticz:2024.7

I ran the command and the restarted instance still shows the empty panels.

Also went inside the container to check the CounterLog.html file. It apparently DOES contain the month- and year-charts.

root@3fbd056f7fff:/opt/domoticz/www/app/log# cat CouterLog.html
cat: CouterLog.html: No such file or directory
root@3fbd056f7fff:/opt/domoticz/www/app/log# cat CounterLog.html
<counter-day-chart
class="device-log-chart"
device="::$ctrl.device"></counter-day-chart>

<counter-week-chart
class="device-log-chart"
device="::$ctrl.device"></counter-week-chart>

<counter-month-chart
class="device-log-chart"
device="::$ctrl.device"></counter-month-chart>

<counter-year-chart
class="device-log-chart"
device="::$ctrl.device"></counter-year-chart>

<counter-compare-chart
ng-if="::$ctrl.subtype=='energy-used' || $ctrl.subtype=='gas' || $ctrl.subtype=='water' || $ctrl.subtype=='counter' || $ctrl.subtype=='energy-generated' || $ctrl.subtype=='time' || $ctrl.subtype=='p1Energy' || $ctrl.subtype=='instantAndCounter'"
class="device-log-chart"
device="::$ctrl.device"></counter-compare-chart>
jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Re: Usage data last month and last year not displaying anything

Post by jacobh »

Just by means of excluding I also tested by installing Safari browser on my primary laptop and by opening the page on a laptop that never used Domoticz before. Both panes are still there.

So the /opt/domoticz/www folder in docker is mounted on my local filesystem, so be removing the counter-month-chart and counter-year-chart tags, they are gone now. Still wondering however what causes this issue.

Let me say thanks for your patience with me and your ideas to get things solved and explaining things.
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

I am no docker expert but t seems by mounting extra folders you hampered the update process. Can you post your complete docker compose file?
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
jacobh
Posts: 19
Joined: Wednesday 04 November 2020 10:12
Target OS: -
Domoticz version:
Contact:

Re: Usage data last month and last year not displaying anything

Post by jacobh »

networks:
default:
driver: bridge
ipam:
driver: default
monitoring:

services:
domoticz:
image: domoticz/domoticz:2024.7
container_name: domoticz
restart: unless-stopped
devices:
- /dev/serial/by-id/usb-RFXCOM_RFXtrx433XL_DO3RW0UN-if00-port0:/dev/serial/by-id/usb-RFXCOM_RFXtrx433XL_DO3RW0UN-if00-port0
ports:
- "9080:8080"
volumes:
- /home/pi/docker/volumes/domoticz/config:/opt/domoticz/userdata
- /home/pi/docker/volumes/domoticz/config/www:/opt/domoticz/www
- /home/pi/docker/volumes/domoticz/config/backups:/opt/domoticz/backups
- /home/pi/docker/volumes/domoticz/www/templates:/domoticz/www/templates
- /home/pi/docker/volumes/domoticz/config/plugins:/opt/domoticz/plugins
environment:
- TZ=Europe/Amsterdam
- LOG_PATH=/opt/domoticz/userdata/domoticz.log
- EXTRA_CMD_ARG= -loglevel normal,status,error,auth
User avatar
waltervl
Posts: 5396
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Usage data last month and last year not displaying anything

Post by waltervl »

Again, I am not a docker expert but mounting opt/domoticz/www does not seem correct.

Normally only /opt/domoticz/userdata needs to be mounted.
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests