[SOLVED] Grouping rows and summing each group
Hi.
I would like your advice.
I have a dataset which has around 180 rows relating to one date, and another 180 rows relating to a second date, and so on.
I want to sum the attributes for those 180 rows of the first date, and I want to sum the atrributes of the 180 rows of the second date, etc.
I have tried to do this using the Aggreate operator, but it just produces averages. I can't get it to produce sums.
Do you happen to know if there is an operator which will sum the rows according to each date?
Or maybe I am using the Aggregate operator incorrectly.
Either way, I would glady appreciate your input and experience on this.
Thank you.
Bob
I would like your advice.
I have a dataset which has around 180 rows relating to one date, and another 180 rows relating to a second date, and so on.
I want to sum the attributes for those 180 rows of the first date, and I want to sum the atrributes of the 180 rows of the second date, etc.
I have tried to do this using the Aggreate operator, but it just produces averages. I can't get it to produce sums.
Do you happen to know if there is an operator which will sum the rows according to each date?
Or maybe I am using the Aggregate operator incorrectly.
Either way, I would glady appreciate your input and experience on this.
Thank you.
Bob