Forum

Group range of numb...
 
Notifications
Clear all

Group range of numbers into buckets

3 Posts
2 Users
0 Reactions
857 Views
(@jason-wier)
Posts: 23
Eminent Member
Topic starter
 

I have a column that contains numbers.  I want to add a new column that groups the first column into specific "buckets".

Bucket grouping: 1-15, 16-30, 31-45,46-60, >60.

Note: The column also contains numbers less than zero.  I don not want to includes these in my buckets.

Sample excel file attached. 

Thank you. 

 
Posted : 29/09/2021 8:35 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Jason,

See attached file for solution using this code

if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 1 and [#"Difference in Days - Paid Date vs Last Scan Date"] <= 15 then "1-15"

else if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 16 and [#"Difference in Days - Paid Date vs Last Scan Date"] <= 30 then "16-30"

else if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 31 and [#"Difference in Days - Paid Date vs Last Scan Date"] <= 45 then "31-45"

else if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 46 and [#"Difference in Days - Paid Date vs Last Scan Date"] <= 60 then "46-60"

else if [#"Difference in Days - Paid Date vs Last Scan Date"] > 60 then ">60"

else null

 

Regards

Phil

 
Posted : 29/09/2021 7:44 pm
(@jason-wier)
Posts: 23
Eminent Member
Topic starter
 

This was perfect!!!  You all are just incredible! Thank you!

 
Posted : 30/09/2021 5:14 pm
Share: