Last Modified Date: 27 Mar 2017
Environment
Tableau DesktopAnswer
Create a new calculated field to replace the original moving average calculation using the formula below:IF ISNULL(LOOKUP(SUM([Measure]),-X)) THEN NULL ELSE WINDOW_AVG(SUM([Measure]), -X, 0) END"X" is the number of days that the moving average is computed from. This calculation allows the moving average to only be computed if there are at least X days worth of data, and will display a NULL if there aren't enough.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials