Graphing average values based on time stamps

[dan...@sesconsulting.com]

Hi Everyone,

I am creating a line graph in SlamData. It is a graph of values over time.

My database has a new record inserted into it every 30 seconds.

How would I display a new point based on the average of an hour or a day rather than all individual points (every 30 seconds) while still keeping the time-stamp as the X-axis?

I want to do this because it isn't necessary to show every point of data when looking at a large time-span on the graph.

Does anyone have any ideas?

Thanks,

Daniel