The Aggregate analytic lets you create quick "buckets" of data for a particular column.
The Partition Window command lets you partition rows into groups using the columns in a particular column.
To implement a Aggregate command
|2.||Enter a column name for the resulting column.|
|3.||Select a column to aggregate. This column must contain numerical data.|
|4.||Select an operation to aggregate values for the new column. This might be an average temperature, or a running total. See Operations Used in Commands for more details on these operations.|
|5.||Select a length and unit for the aggregation window, such as "1 hour" or "15 minutes."|
|6.||Click the + icon to add the command to the Guide script.|
|7.||The results of the script appear in the Output View window.|