Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.

Choose Language Hide Translation Bar

Level IV

May 23, 2015 07:21 AM (11747 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

1 ACCEPTED SOLUTION

Accepted Solutions

Super User (Alumni)

Super User (Alumni)

May 23, 2015 11:14 AM (14552 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

Super User (Alumni)

Super User (Alumni)

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

Try this column formula :

If(Row() > 6,

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

);

Level IV

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

Thank you!

Level IV

Jun 8, 2015 10:32 AM (11586 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