topic Re: How to Rolling Average in Discussions https://community.jmp.com/t5/Discussions/How-to-Rolling-Average/m-p/12496#M11888 <HTML><HEAD></HEAD><BODY><P>Hi MS,</P><P></P><P>Would you please show me how to add "by variable" to the script above?</P><P>Sales by Year,</P><P>Sales by Year by Agency</P><P>Sales By Year by Agency by Month...</P><P></P><P>Many thanks in advance</P></BODY></HTML> Mon, 08 Jun 2015 14:32:11 GMT saitcopuroglu 2015-06-08T14:32:11Z How to Rolling Average https://community.jmp.com/t5/Discussions/How-to-Rolling-Average/m-p/12493#M11885 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>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</P><P></P><P>many thanks in advance</P></BODY></HTML> Sat, 23 May 2015 11:21:56 GMT https://community.jmp.com/t5/Discussions/How-to-Rolling-Average/m-p/12493#M11885 saitcopuroglu 2015-05-23T11:21:56Z Re: How to Rolling Average https://community.jmp.com/t5/Discussions/How-to-Rolling-Average/m-p/12494#M11886 <HTML><HEAD></HEAD><BODY><P>Try this column formula :</P><P></P><P style="font-family: Courier;"><SPAN style="color: #032ce4;">If</SPAN><STRONG>(</STRONG><SPAN style="color: #032ce4;">Row</SPAN><STRONG>()</STRONG> <SPAN style="color: #011993;">&gt;</SPAN> <SPAN style="color: #009193;"><STRONG>6</STRONG></SPAN><SPAN style="color: #011993;">,</SPAN></P><P style="font-family: Courier;">&nbsp;&nbsp;&nbsp; <SPAN style="color: #032ce4;">Mean</SPAN><STRONG>(</STRONG><SPAN style="color: #011993;">:Sales</SPAN><STRONG>[</STRONG><SPAN style="color: #032ce4;">Index</SPAN><STRONG>(</STRONG><SPAN style="color: #032ce4;">Row</SPAN><STRONG>()</STRONG> <SPAN style="color: #011993;">-</SPAN> <SPAN style="color: #009193;"><STRONG>6</STRONG></SPAN><SPAN style="color: #011993;">,</SPAN> <SPAN style="color: #032ce4;">Row</SPAN><STRONG>())])</STRONG></P><P style="font-family: Courier;"><STRONG>)</STRONG><SPAN style="color: #011993;">;</SPAN></P><P><SPAN style="color: #011993;"><BR /></SPAN></P></BODY></HTML> Sat, 23 May 2015 15:14:51 GMT https://community.jmp.com/t5/Discussions/How-to-Rolling-Average/m-p/12494#M11886 ms 2015-05-23T15:14:51Z Re: How to Rolling Average https://community.jmp.com/t5/Discussions/How-to-Rolling-Average/m-p/12495#M11887 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Sat, 23 May 2015 16:43:08 GMT https://community.jmp.com/t5/Discussions/How-to-Rolling-Average/m-p/12495#M11887 saitcopuroglu 2015-05-23T16:43:08Z Re: How to Rolling Average https://community.jmp.com/t5/Discussions/How-to-Rolling-Average/m-p/12496#M11888 <HTML><HEAD></HEAD><BODY><P>Hi MS,</P><P></P><P>Would you please show me how to add "by variable" to the script above?</P><P>Sales by Year,</P><P>Sales by Year by Agency</P><P>Sales By Year by Agency by Month...</P><P></P><P>Many thanks in advance</P></BODY></HTML> Mon, 08 Jun 2015 14:32:11 GMT https://community.jmp.com/t5/Discussions/How-to-Rolling-Average/m-p/12496#M11888 saitcopuroglu 2015-06-08T14:32:11Z