Getting year log data by month

[Triangle]

Hi, For my frontpage (thanks G3rard) I'm making some small changes/additions. One of them is my solar energy production. I have the day graph and the mont graph. Both displayed as sparklines. I do like to have a year graph with totals for each month. I can get the data:

Code: Select all

/json.htm?type=graph&sensor=counter&idx=69&range=year

But data is a total per day. Is there a json api call to get the data as in domoticz itself (under report), or do I have to total the data myself?

[Egregius]

Total it yourself, or maybe read it directly from the database and let sql total it with a group by statement.

[franzelare]

how do you display graphs on your frontpage, also want do display some graphs on my custom frontpage...

[Triangle]

I used http://omnipotent.net/jquery.sparkline/#s-about and an ajax call in frontpage.js.