tAggregateRow example
In the following example, the tAggregateRow component is configured to aggregate students' comprehensive scores based on the student names. The aggregation result will include the total score, average score, highest score, and lowest score of each student.
setSettings {
GROUPBYS {
OUTPUT_COLUMN : "name",
INPUT_COLUMN : "name"
},
OPERATIONS {
OUTPUT_COLUMN : "sum",
FUNCTION : "sum",
INPUT_COLUMN : "score",
OUTPUT_COLUMN : "average",
FUNCTION : "avg",
INPUT_COLUMN : "score",
OUTPUT_COLUMN : "max",
FUNCTION : "max",
INPUT_COLUMN : "score",
OUTPUT_COLUMN : "min",
FUNCTION : "min",
INPUT_COLUMN : "score"
}
}Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!