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 |