cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
saitcopuroglu
saitcopuroglu
Level IV

How to Rolling Average

May 23, 2015 07:21 AM (10083 views)

Hi All,

I have a column which displays the actual sales day bay day. I would like to have a column which takes the average of last seven days (Rolling Average)? As a result the first 6 row is missing and the data starts on 7th fo the first 7 days mean at 8th the 2nd to 8th rows mean, at 9th the 3rd to 9th mean...and so on

many thanks in advance

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)
Solution

Re: How to Rolling Average

May 23, 2015 11:14 AM (12888 views)  |  Posted in reply to message from saitcopuroglu 05-23-2015

Try this column formula :

If(Row() > 6,

    Mean(:Sales[Index(Row() - 6, Row())])

);


View solution in original post

3 REPLIES 3
ms
Super User (Alumni) ms
Super User (Alumni)
Solution

Re: How to Rolling Average

May 23, 2015 11:14 AM (12889 views)  |  Posted in reply to message from saitcopuroglu 05-23-2015

Try this column formula :

If(Row() > 6,

    Mean(:Sales[Index(Row() - 6, Row())])

);


saitcopuroglu
saitcopuroglu
Level IV

Re: How to Rolling Average

May 23, 2015 12:43 PM (9922 views)  |  Posted in reply to message from ms 05-23-2015

Thank you!

0 Kudos
saitcopuroglu
saitcopuroglu
Level IV

Re: How to Rolling Average

Jun 8, 2015 10:32 AM (9922 views)  |  Posted in reply to message from ms 05-23-2015

Hi MS,

Would you please show me how to add "by variable" to the script above?

Sales by Year,

Sales by Year by Agency

Sales By Year by Agency by Month...

Many thanks in advance

0 Kudos