search

genielabs / HomeGenie

HomeGenie, the programmable automation intelligence
https://homegenie.it
GNU General Public License v3.0
402 stars 157 forks source link

Request: Bigger Statistics - more options than 24h #17

Closed ado464 closed 9 years ago

ado464 commented 10 years ago

I would love the statistics to be built up a bit, so you have a choice to show 1week 2weeks 3, and so on and not only the first 24h. The database is about 10mb so this should work? I understand it is a lot of work, but it would be a wonderful feature.

Cheers, A.

ado464 commented 10 years ago

I have noticed this in the html/pages/analyze/main.html

skarmavbild 2014-08-13 kl 11 48 09

it is planned, not working yet but anyone have any idea on how to make it run? :)

cheers, A.

genemars commented 10 years ago

this feature was planned time ago, but currently not implemented.

hybridview commented 9 years ago

I would love this feature as well. Maybe I'll take a stab at it in my spare time.

gitbjo commented 9 years ago

Hi, I have also needs regarding the statistics like the above mentioned and also to be able to include data of several sensors in the same graph. Some other features like zoom and pan would make the data analysis more flexible. I'm also ready to give a hand on that, but due to some stress in my work, I can only spend little time in the coming weeks. March should get easier. But may be we can setup some specs to start on this and Gene can help us to give directions on how it works today and where we should look at to extend it. Regards, gitbjo

hybridview commented 9 years ago

I was just thinking about pan and zoom support. For my Home Energy Monitor, I would be able to see very detailed charts (a couple of hours for example). Zoomed in, I would be able to enhance the resolution timer from every 5 minutes to every 30 seconds and see detailed spikes in usage. I just submitted a pull request that has some initial enhancements to the statistics DB queries for custom date range support and finer resolution. I was also able to learn how the statistics system functions (UI interactions/web service/database). It's a nice architecture and is very extensible.

Discussing some requirements/specs would be a great way to get everyone on the same page. My initial effort was primarily to make the statistics more configurable so I wouldn't have to recompile. Protecting the existing DB queries from SQL injection was also a good thing to nail down.

genemars commented 9 years ago

@gitbjo @hybridview see what's new in r476. Date range selection and pan and zoom support has been added. For requests that are not strictly related to this issue topic, please open a new issue.

genemars commented 9 years ago

@gitbjo "Gene can help us to give directions on how it works today and where we should look at to extend it." Sure I would. I think a better place for this is the forum.