The following parameters are available.
Action |
Result |
---|---|
Dimension column |
Name of dimension column. Source: Source table Data type: Date, Number, or Text The default value: {None} Specification: Optional |
Aggregation column |
Name of the column to be aggregated. Source: Aggregation column is transferred from the source table. Data type: Number The default value: {None} Specification: Optional |
Aggregation type |
Aggregation type for the column to be aggregated: Average value, Sum, Minimum, Maximum, Count, First row and Last row. The default value: Average value, if aggregation column selected. Specification: Mandatory, if aggregation column selected. |
Weighting |
If the aggregation type is Average value or Sum, a numerical column for weighting of the rows can be specified for each column to be aggregated. Specification: Optional |