Results 1 to 24 of 24
Thread: Moving average
Oct 29, 2013, 07:46 #1
Hello guys, I've problem with MySQL and need your help.
I attach the file xlsx in the test.zip.
This file xlsx is able to calculate the moving average (column G - AVERAGE_12_MONTHS) of the column F (F_SUM).
The average is dynamic because in the column G is a line feed, e.g.:
In the cell G13 I've the average of cell F2:F13, in the cell G14 the average is of cells F3:F14, in the cell G15 the average is of cells F4:F15... etc
I need realize the same average in mysql, any suggestion?
Can you help me?
Any help would be very appreciated