Page 1 of 1

Getting year log data by month

Posted: Monday 29 February 2016 16:36
by 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? :roll:

Re: Getting year log data by month

Posted: Monday 29 February 2016 22:46
by Egregius
Total it yourself, or maybe read it directly from the database and let sql total it with a group by statement.

Re: Getting year log data by month

Posted: Sunday 05 February 2017 7:55
by franzelare
how do you display graphs on your frontpage, also want do display some graphs on my custom frontpage...

Re: Getting year log data by month

Posted: Friday 17 February 2017 9:11
by Triangle
I used http://omnipotent.net/jquery.sparkline/#s-about and an ajax call in frontpage.js.