grouping by a unique value

[Badrelouizi]

I am hoping to get help with this. Here is the input & desired output below

ID	Work Date	Hours
313132	4/1/2020	8.216667
313132	4/2/2020	8.083333
313132	4/3/2020	8.25
313132	4/6/2020	8.116667
313132	4/7/2020	8.15
313132	4/8/2020	8.85
313132	4/9/2020	7.4
313132	4/10/2020	8.466667
313132	4/14/2020	5.5
313132	4/15/2020	8.25
313132	4/16/2020	8.083333
313132	4/17/2020	8.25
313132	4/20/2020	8.216667
313132	4/21/2020	8.683333
313132	4/22/2020	7.666667
313132	4/23/2020	8.083333
313132	4/24/2020	8.083333
313132	4/27/2020	8.083333
313132	4/28/2020	8.1
313132	4/29/2020	8.2
313132	4/30/2020	8.116667
382855	4/1/2020	9.65
382855	4/2/2020	10.91667
382855	4/3/2020	10.91667
382855	4/6/2020	11.11667
382855	4/7/2020	10.61667
382855	4/8/2020	0.083333
382855	4/9/2020	9.3
382855	4/10/2020	11.45
382855	4/13/2020	11.35
382855	4/14/2020	9.983333
382855	4/15/2020	9.916667
382855	4/16/2020	9.3
382855	4/17/2020	9.65
382855	4/20/2020	9.866667
382855	4/21/2020	9.233333
382855	4/22/2020	9.133333
382855	4/23/2020	8.783333
382855	4/24/2020	9.25

The output should be like this:

ID	Work Date	AvgHours
313132	April	8.04
382855	April	9.47

Thank you in advance

[brendafos · Accepted solution]

I've used the Formula tool to make a new field Month

Then used the Summarize tool to Group by the ID, then Group by Month, then Avg the Workhours

If this is what you needed, please, set this as the Solution.

Thanks

[Badrelouizi]

Thank you 🙂