Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Summing Range Max

I'm trying to sum the greatest number of hours for every day.

i.e. I want the sum of the bolded numbers below: 19

DateHours
1/2/20112
1/2/20113
1/2/20114
1/3/20112
1/3/20114
1/3/20119
1/3/20112
1/4/20113
1/4/20116

I can't sum(max(hours), any other ideas?

1 Reply
Not applicable
Author

sum(aggr(max(hours),Date))