Forum Discussion
dataversep
Nov 15, 2022Copper Contributor
Age buckets
I have a calculated column called age in my sharepoint list and another field called dateOfBirth and id.
I need to create another field in the sharepoint list called age buckets. For example : 0-5, 5-8-8-12 and so few more.
Age_bucket Count of number of id in that age bucket
0-5 8
5-8 3
8-12 5
Please let me know the best way for this.
dataversep Try this approach:
- Create one more calculated column in list which will show 0-5, 5-8 or 8-12 value based on your calculated column (age).
- Then applying grouping on this newly created column in list view
Documentation: Use grouping to modify a list or library view
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.