Does any know how to set customized bin range for the Histogram tool?
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 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.
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
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?
