ehryk/arduinomonitor

Log your Arduino sensor data to a file or database!

arduinomonitor's Issues

Split the datagrid and graph into reusable `Partial`s

Move the jQuery Datatable and Flot Chart into their own partial for easy reuse across many pages

We need a graph!

Could you do a flot chart on Home/Dashboard in the <section id="graph"> at the top? I'll be moving the data grid and graph to their own partials later so they'll be more usable across pages, but this'll be good for now.

Can you use the function drawGraph(data) that to do the drawing? I'm locked into using $.dataTables to load the data, and it would prefer to keep it a single call. I've already added $.flot, as well as the resize, time, and crosshair flot plugins to the script bundle.

Desired effects:
Crosshair: http://www.flotcharts.org/flot/examples/tracking/index.html
Multiple Axes (-5° to 105° and 0% to 100%): http://www.flotcharts.org/flot/examples/axes-multiple/index.html
Auto-resizing with the window: http://www.flotcharts.org/flot/examples/resize/index.html

Yay data visualization!

Add a SensorDataGraphAverage stored procedure that computes averages

This might be an interesting challenge in T-SQL:

The current SensorDataGraph procedure grabs n 'Points', evenly spaced across the data points available, but not necessarily even slices of time.

While this worked for my initial purpose, it will not be very useful over longer periods (some points will be at night and some during the day, for example).

What I'd like to do is rename the procedure to SensorDataGraphPoints, and have another one SensorDataGraphAverage that computes the average over the n datapoints in that 'region'. This may be a good use for PARTITION() OVER () or some other interesting T-SQL.