ThoughtSpot Moving Functions
SME Solutions Group has launched a new video series called the SME 2 Minute Drill. In this video series, subject matter experts cover a topic in 2 minutes or less.
They are kicking off the series with ThoughtSpot! The SME Team has produced nearly 50 videos, all 2 minutes or less, that cover everything you need to know about using ThoughtSpot from Getting Started to R scripts and beyond!
In this video:
Moving formulas are aggregate formulas that allow you to calculate the average, max, min, or sum of your data over a predetermined interval, or window, with an adjustable range.
Moving formulas can be used to smooth out any irregularities in your data to easily recognize trends. The larger the interval you set, the more the peaks and valleys are smoothed out. While the smaller the interval, the closer the moving averages are to the actual data points.
You can download this exact dataset to follow along