How to set custom bins for Histogram

[BrockYang]

Does any know how to set customized bin range for the Histogram tool?

[DiganP]

@BrockYang You would have to do the binning before putting in the histogram tool. You can use the multi-field binding tool, formula or tile tool. 

You can also leverage the R tool to create your own R based histogram. 

[Jonathan-Sherman]

Hi @BrockYang,

Is there any reason you can't set them manually through an IF statement using a formula tool? You can find more information here https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Custom-Binning-in-Alteryx/td-p/172679

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[BrockYang]

In the example you provided, if I created a new column called "Age Group" which contains the values of "<18", "18 to 65" and ">65", the Histogram tool does not seem to allow me to select "Age Group" as the field to use in the histogram (the dropdown list only shows numeric columns).  How would I overcome that?  Should I try to make the "Age Group" column a numeric field and set the value to "18", "65", "66"?  Or am I missing something?

[Jonathan-Sherman · Accepted solution]

You're correct @BrockYang, once you've changed them to numeric it should work for you.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[BrockYang]

This appears to be a bit of "patch" solution (e.g.,using "66" to represent >65, in the simple example we used).  Ideally, it would be great to be able to set customized numeric bin range in the Histogram tool.  Thoughts?  Thank you for the help.