Domoticz

Is it possible to have as a graph not only day, month, year but also hour?

So it also would be nice to have in the other graphs, an opacity graph underneat it with the highest values.
So you can detect extremes, which does not show up on the day graph... something to detect spikes...

ke stupid me, i found out you could zoom in...

Still can't see spikes thou

Something like this?



I store temperatures every minute in a MySQL database. After that, I can do whatever I want with them

So how do you produce the graph?

The chart is produced by https://github.com/Egregius/PHP-Custom- ... /chart.php
Example usage at https://github.com/Egregius/PHP-Custom- ... r/temp.php

With the temperatures stored every minute in MySQL I can easily calculate min/avg/max based on the timestamp. I do that by grouping on the left characters of the timestamp. So possibilities are 10 minutes, 1 hour, 1 day, 1 month, ...
I did it this way because I wanted to store all temperatures for a while. Normally this week my house gets extra insulation so I hope I can see the difference in the graphs.
Will extend my script then so I can have 2 days plotted in 1 graph (or something like that).

Egregius, can you share your script how to export from Domoticz to a mysql database and how to implement it?
Thanks!

@egregius

Just for quick understanding ( avoiding the need/effort to read/dissect your scripts):
at what location is your resulting MySQL-database (at computer running Domoticz?, or elsewhere?)?

Reason for the question:
I am looking for a solution to get a graph/chart at a remote website, which means that somehow I have to transfer&convert information between Domoticz and the websiteserver. See http://www.domoticz.com/forum/viewtopic ... 28&t=13537