cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Discover peer insights or crowdsource your one of a kind Designer question.

Custom Binning in Alteryx

SOLVED
Highlighted

Hi all, 

 

I am trying to figure out how to bin values in alteryx using custom range. I have an "age" field and some how i want to group them in bins of:

 

- 0 to 17 

- 18 to 29 

- 30 to 69

- 70 to 79

- 80 + 

 

 

Is there any way i can bin these and give this a new field name i.e " Age Group".

 

I have tried using the multiple binning tool but it dose't allow me to specify values. 

 

 

Thanks, 

Aqil 

Magnetar
Magnetar

Hi @AQILKURJI,

A formula tool can do this: new field "AgeGroup" with:

IF [Age] <= 17 THEN
  "Group1"
ELSEIF [AGE] <= 29 THEN
  "Group2"
ELSEIF [AGE] <= 69 THEN
  "Group3"
ELSEIF [AGE] <= 79 THEN
  "Group4"
ELSE
  "Group5"
ENDIF

 ... where the values are whatever you want, whatever field type you want.

Hope that helps!

John

 

Thanks John !