Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Binning based on equal distribution

whitkrieng
8 - Asteroid

Hi all, 

I'm trying to find an optimal tool to try and Bin a number of records into say 5 or 10 group of equal records.  I feel the Tile tool is only able to bin into 3 groups based on the standard deviation.  

 

For example say I have a dataset that is items sold: 

RecordIDItems Sold
110
25
37
44
55
61
78
89
97
109
118
127
137
142
152
167
173
185
196
201
213

 

I want to find out what range I should set to say have 3 groups with a equal count in each group (in this case 7 records in each group).  Is there a certain tool that would be able to auto-calculate that? 

 

Thanks! 

3 REPLIES 3
Garabujo7
Alteryx
Alteryx

Hello @whitkrieng ,

 

Have you tried the tile tool with the Equal Records Method?

 

 

Garabujo7_0-1634598280790.png

 

I got three groups with 7 records each:

 

Garabujo7_1-1634598354066.png

 

 

Gabriel

whitkrieng
8 - Asteroid

Thanks for your response, I think the Equal Records clusters it randomly.  So in my instance, I want an algorithmic way to group the "Items Sold" in 3 buckets determined by the distribution of the "Items Sold".  If say there are 7 records for 1,2, and 3 # of "Items Sold" then I would construct a bucket of "1-3 Items Sold". Then the next bucket could "4-5 Items Sold" and last "6-10 Items" Sold. 

 

 

mceleavey
17 - Castor
17 - Castor

Hi @whitkrieng ,

 

you may be talking about the multi-field binning tool. I've built an example around a 7 group distribution based on Items sold:

 

mceleavey_0-1634657752695.pngmceleavey_1-1634657763414.png

 

mceleavey_2-1634657781514.png

 

I've attached the build and you can mess around with the configuration of the binning tool.

 

Hope this helps,

 

M.

 

 



Bulien

Labels