lodedeecte
New Member
I'm trying to realise a moving average in a prediction-platform using the HighStock charting library. The moving average wil be used to lessen the influence of a single users prediction on the graph for the whole prediction. Just plotting every single prediction would make the graph volatile and confuseing.But I would still like to implement the zoom-function included in HighStock (down to minute level) so the SQL Query sholud contain all the values, except now as a moveing average.My current prediction table contains the date and all the predicitons made by users as a percentage value (int) from 0 to 100%.Do I need an additional table to save the moving average? If yes, how do I procced if no predictions are made by users for a longer time? How could an SQL query look like that reads and saves the moving average?Many thanks in advance for your answers.