Age buckets

Copper Contributor

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.

1 Reply

@dataversep Try this approach:

  1. Create one more calculated column in list which will show 0-5, 5-8 or 8-12 value based on your calculated column (age).
  2. Then applying grouping on this newly created column in list view

DocumentationUse 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.