How to count rows with simillar day of the month and ADD (SUM)

Hi,

I have a table one row per web visitor with the daily average temp and temp category for each row
can you please help how to count the users and put the sum for the day instead of one row per visitor
Sample work fellow will be appreciated Thank you

below is the sample and attached is the CSV file Files.zip (320 Bytes)

Date visitor Daily Avg temp category
1/1/2015 1 15 Average
1/1/2015 1 15 Average
1/1/2015 1 15 Average
1/1/2015 1 15 Average
1/1/2015 1 15 Average
1/1/2015 1 15 Average
2/1/2015 1 25 Hot
2/1/2015 1 25 Hot
2/1/2015 1 25 Hot
2/1/2015 1 25 Hot
2/1/2015 1 25 Hot
2/1/2015 1 25 Hot
2/1/2015 1 25 Hot
3/1/2015 1 5 Cold
3/1/2015 1 5 Cold
3/1/2015 1 5 Cold
3/1/2015 1 5 Cold
3/1/2015 1 5 Cold
1/2/2015 1 10 Moderate
1/2/2015 1 10 Moderate
1/2/2015 1 10 Moderate
1/2/2015 1 10 Moderate
1/2/2015 1 10 Moderate
1/2/2015 10 Moderate

I would like to have the following output table

Date visitor Daily Avg temp category
1/1/2015 6 15 Average
2/1/2015 7 25 Hot
3/1/2015 5 5 Cold
1/2/2015 6 10 Moderate

Hi @Shalombr -

I’ve attached an example workflow. All you really need here is the GroupBy node. Check the Groups and Manual Aggregation tabs in the configuration dialog to see the specifics.

2018-05-21%2013_51_24-Group%20table%20-%200_2%20-%20GroupBy

GroupByTempExample.knwf (6.1 KB)

1 Like

It worked thank you very much

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.