Tip of the Week : Moving Calculation
With some datasets, you may find it difficult to comprehend the general trend. This is because the data points can fluctuate widely. Take for example website page visits, ad impressions, or stock prices. They vary continuously, and this is where Moving Calculation can help you see the trend more easily.
Moving Calculation averages the values over a specified time span, with a more smooth curve. The below recording shows how you can create a 30 day moving average curve.
The summary function selected will be taken as the base for calculation. You can choose the usual Sum, Average, Minimum and Maximum functions for Moving Calculation too, with Average being the most used function.