This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thisarticle is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the TS Filler Tool on our way to mastering the Alteryx Designer:
Time-series forecasting is the use of a statistical model to predict future values based on past results. So what can these future and past values be? Any variable that can be tracked and collected over time! Think of annual population data, a company's daily stock price, or quarterly sales figures. For our examples we will be working with bookings data gathered from a mountain resort hotel.
How should this data be collected?
Over a continuous time interval
Of sequential measurements across that interval
Using equal spacing between every two consecutive measurements and
With each time unit within the time interval having at most one data point
Once the data has been structured to fit this format, Atleryx has a host of Time Series Tools to help you display, analyze and predict future values. This is done with the same easy drag and drop interface that you've come to know and love!
Let's take a look at these tools a bit more in depth...
TS Filler - Takes a data stream of time series data and fills in any gaps in the series.
So what happens when your data doesn't fit the collection methods for time series analysis because of missing periods? Give up? Stop Analyzing? NEVER! The TS Filler tool will help you fill in the missing periods. It's then up to you to find the best imputation method to fill in the missing values.
Key Terms to Understand:
Imputation- The process of replacing missing data with substituted values.
TS Plot Configuration Properties:
Select Date or DateTime column: Choose the date or datetime column indicating when the data row was collected
Interval:Select the interval by which the time series is measured. Options:
Increment:Select the increment by which each unique time series period should be separated. Options:
Any integer from1 to 100
For example, to generate a series covering “every 3 weeks” you would choose “Week” for the interval and 3 for the increment.
Check out the attached v11.3 workflow, TS Filler.yxzp, for a working example of the tool in action!
By now, you should have expert-level proficiency with the TS Filler Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know email@example.com you’d like your creative tool uses to be featured in the Tool Mastery Series.
Stay tuned with our latest posts everyTool Tuesday by followingAlteryx on Twitter! If you want to master all the Designer tools, considersubscribing for email notifications.