¶ Description
Sum N rows.
¶ Parameters
¶ Parameters tab
Parameters:
- Columns to average
- Size of rows set when averaging
¶ Description tab
Parameters:
- Script name
- Short description
- Revision
- Decription
¶ Configuration tab
See dedicated page for more information.
¶ About
This action can be summarized as a "group by" 'n' consecutive rows Action.
Let's assume that:
- You want to create a chart in excel that represents the average SALES amount per week.
- You have an original table that contains, for each day, the SALES amount:
i.e. You want to obtain the following table, to be able to create your chart:
The objective of this operator is to obain the final "TRANSFORMED TABLE" based on the "ORIGINAL TABLE".
NOTE:
This operator is mainly useful when you want to reduce the number of rows of a table to obtain a "synthetized" version that is more suitable for visualization. In normal situation, this operator should not be used in conjunction with a predictive analysis because the "TRANSFORMED TABLE" contains a lot less information compared to the "ORIGINAL TABLE" and will usually generate less accurate predictive models.
