Lag
See the trends and patterns that emerge from transformed data using the Lag tool.
Create a new, transformed series of data from your original data. Specify the Date column, Frequency, and rows to Analyze by. For the lag, enter the New column name, the Aggregate column, the Operation and the Lag number.
You can create multiple aggregate columns for your data. Each aggregate column is added to the data as a new column.
When to use this tool
Use the Lag tool when you want to see the trends and patterns that emerge from the transformed data. For example, you can use the Lag tool to view your revenue month over month. The Lag tool gives you a row over row comparison.
Note
The Lag tool only performs the operation to the end of the data. It does not make predictions about the data.