MySQL Forums :: Newbie :: Moving average


Advanced Search

Moving average
Posted by: angel rivero ()
Date: October 29, 2013 08:56AM

Moving average

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

http://myaccount.dropsend.com/file/0a5f969ee425f957

Options: ReplyQuote


Subject Written By Posted
Moving average angel rivero 10/29/2013 08:56AM
Re: Moving average angel rivero 10/29/2013 11:51AM
Re: Moving average angel rivero 10/30/2013 02:40AM
Re: Moving average Peter Brawley 10/30/2013 10:06AM
Re: Moving average angel rivero 10/30/2013 10:24AM
Re: Moving average Peter Brawley 10/30/2013 01:10PM
Re: Moving average Rick James 11/02/2013 04:15PM
Re: Moving average angel rivero 11/03/2013 04:18AM
Re: Moving average Rick James 11/03/2013 10:36PM
Re: Moving average angel rivero 11/04/2013 04:53AM
Re: Moving average Rick James 11/04/2013 10:52PM
Re: Moving average angel rivero 11/05/2013 02:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.