This project has moved and is read-only. For the latest updates, please go here.

Yearly report ?

Topics: 1. General
Mar 1, 2015 at 9:38 AM
There all,

First of all, I would like to thank you for the great work and great tool you developed ! :)

Now my question/problem : I joined the tool with canvasjs so I can have some nice graph about the production on a daily and monthly basis. As it's now a couple of month that I do have the installation running and producing, I would be interested to make similar graph on a yearly basis.
I can't find a yearly report.

Is there an easy configuration to do to have it or does it need some development ?

Kr
Mar 1, 2015 at 10:06 PM
With canvas you mean PVoutput.org?
You don't see the "Year" link?
Mar 2, 2015 at 7:46 AM
No, I'm not yusing PVoutput.orgas I was not able to get the data sent to PVoutput.
What is implemented is a small local web server with HTML pages I do use to display reports in a graphical way (using CanvasJS).
The graphs use the daily and monthly report to show instant production and cumulative production.
What I'm missing now is a yearly report that I could not retrieve in the list of all available reports
Mar 2, 2015 at 11:57 AM
Edited Mar 2, 2015 at 9:45 PM
You have to create a view in your db to group the monthdata per year
--SQLite example
SELECT strftime("%Y", Timestamp) as Year,
    Name,
    Type,
    Serial,
    Sum(DayYield) AS TotalYear
FROM vwMonthData
GROUP BY strftime("%Y", Timestamp)