I’d like to generate some summaries on a weekly/monthly basis. What’s the best way to do this? Thx.
If your data is cumulative kWh or similar, then you can add your feeds to a Graph, select the Type to be “Weekly” or “Monthly”, and then check the Delta option on each feed.
If you mean a summary on a Dashboard, then the kwhperiod widget is the one to use.
I’ve suggested before a mechanism to convert old data into summary data, so a process to convert a feed of 10s Temperature data into a feed of daily stats (choice of max/min/average/sum). You could do the same for a monthly/yearly feed. Each time offer the choice to trim (or leave) x time period off the source feed.
Really just needs a new PostProcess (and a way of automating Post Processes). @TrystanLea - any appetite?
Would certainly like to do this. Have a way of easily down sampling feeds. Doesn’t quite fit with having newer data at high res and older data at lower res, but would allow for down sampling data recorded at too high a resolution. It’s a big task and a lot of other things to get through before I can get on to this one but it’s certainly something Im interested in.
1 Like
Have a look at MRTG, the graphing tool for networking. It stores data in files in various different resolutions as it ages. I think it uses ‘rateup’ library behind the scenes.
1 Like
I was thinking of different feeds.
- 10s Feed of external temp.
- Process 10s feed into a daily feed (only processes latest data) and leave x months of 10s data.
- Automatically run process at end of each day (local time).
Isn’t appropriate for all data, so my 10s tank temp data would be meaningless as a daily data feed. But to have an automated ‘trim’ feature would be amazing.
What I was wanting to do is generate monthly figures for my ASHP. One of these is the CoP … hence a calculation required.
Think I’ve managed to do this via generating a monthly feed ‘trigger’ from node-red , which then calculates the delta vs previous month and does the CoP calculation.