I have a MySQL DB with a floating point data (one value for every minute) which should be displayed in an html canvas line chart.
Now to not overload the chart with the huge amount of data, I would like to sample the data values when doing the query so that the total number of rows gets averaged to x
rows.
Can the AVG function be used for this or should I write a php function that averages the data "manually" ?