Domoticz

Hi
Inquiry for energy meter: returns totals for specific days but for the entire year.

I have a suggestion to add the option to provide a parameter from what date it should count, i. e.: Domoticz nicely sums the values from a given period, and due to the fact that not everyone is interested in the sum of values ​​from the period from a year to the present, only from a specific date. If only because of settlement periods.
Regards

You can export to a spreadsheet with the hamburger menu top right.

This API was designed to be used for creating the graphs in Domoticz. For this usage there is no need to add your feature request.
You always can use a script to get these data out for a specific date range.

It seems it was already implemented but not documented yet.....
For counter you can use a data range, notice the "T" between the dates:

where can i add this command to get the results

In whatever python script, dvents script etc where you want to use this......

Hi, I'm looking for one API call where I can see the daily usage and the counters for both the "result" as the "prevresult" payload.
Purpose is to get an calculation of yearly usage based on "to day".

I've noticed that sometimes the dayly usage calculation, every night by domitcz, is returning different values than the counters presents!

The counters itself are not returned in the prevsult part when using &range=year. The daily usage is.
And also are not retrieved when specifing a range : &range=YYYY-MM-DDTYYYY-MM-DD.

The only option I could find is to do TWO API calls:
json.htm?type=graph&sensor=counter&idx=..&range=year&actyear=2024
json.htm?type=graph&sensor=counter&idx=5&range=year&actyear=2023
In both datasets I get the counters ("c") and the daily usage ("v").

The problem here is that you have to do your calculations (my case: calculate past year usage, starting from to day) in a more complex way than when you have one .

infoed wrote: ↑Monday 21 October 2024 14:56
The counters itself are not returned in the prevsult part when using &range=year. The daily usage is.
And also are not retrieved when specifing a range : &range=YYYY-MM-DDTYYYY-MM-DD.
.......
The problem here is that you have to do your calculations (my case: calculate past year usage, starting from to day) in a more complex way than when you have one .

When you have all the daily usage in your preferred range (past year usage, starting from to day) you can add them all up to get the total result. No need to have the counters.

Edit: Here a dzvents example: viewtopic.php?p=193393#p193393