2 Replies Latest reply on Nov 21, 2018 7:00 PM by Paul Wachtler

    Moving Average




      Is there an easy way to calculate 6 weeks moving average without windows function ? Also, if the first few weeks are null or zeros then I need Tableau to calculate the average starting at a number that is >0 for example I have sales: 1,4,4,1,2,8 then my moving average  would be sum of those six numbers divided by 6 but what when  I have 0,0,0,1,2,8, I don't want to average 6 records as the first zeros indicates that this is a new product that started selling three months ago so dividing by 6, it will lower the average sales. Any ideas?