The Time Sort uses a sliding time-based window of incoming rows to reorder those rows by the selected column or by ROWTIME in order to address time synchronization problems with data. For example, sometimes data arriving from multiple sources may not be time-synchronized. Such problems can produce unreliable results from analytics, which typically depend on arriving data being ordered by ROWTIME.
You will likely only need to use this command if you are seeing unreliable results in your data that are time-related.
In the Time Sort command, you can also choose to promote a selected column to rowtime. You do so in cases where you know that another column contains a timestamp more relevant than the time the row entered s-Server. This might be, for example, the time an earthquake actually occurred instead of the time the row enters s-Server. These values can have slight lags, making data calculations less reliable.
To implement a Time Sort command:
|1.||Select a column containing a time stamp.|
|2.||Enter a window length and unit on which to sort rows.|
|3.||Choose whether or not to promote the row to ROWTIME.|
|4.||Click the + icon in the Suggestions list to add the command to the Guide script.|
|5.||The results of the script appear in the Output View window.|