Monthly and annual graphs – online again.

11 04 2012

After a week or so of data gathering, Im pleased to announce that the monthly and annual graphs are now back online. As I write this, there is only 8 days worth of data in them, so they are going to look a little sparse, but the monthly graph will start to rotate in another few weeks, and the rolling annual data will begin to build up again.

For those that asked, the problem we encountered was a poorly thought through order and group by clause in the sql select statement used to populate the data table which is used for the long term min/max data that runs at midnight each day. The resulting data had a 7 day sliding average bias unintentionally inserted by this error.




%d bloggers like this: