Tools to classify/Group/Bin values

Hi Community people,

Is there an easier way to set the below if statement up. Not sure the bin tool is the right one.

Being the great tool alteryx is I am expecting to find a tool that allows you to

> Select the column you want bucketed/binned

> Set the parameters for the intervals

> Set how many intervals you want

IF [Total Rev] = 0 THEN "0" 
ELSEIF [Total Rev] <= 10 THEN "0-10"
elseif [Total Rev] <= 20 then "10-20"
elseif [Total Rev] <= 30 then "20-30"
elseif [Total Rev] <= 40 then "30-40"
elseif [Total Rev] <= 50 then "40-50"
elseif [Total Rev] <= 60 then "50-60"
elseif [Total Rev] <= 70 then "60-70"
elseif [Total Rev] <= 80 then "70-80"
elseif [Total Rev] <= 90 then "80-90"
elseif [Total Rev] <= 100 then "90-100"
elseif [Total Rev] <= 110 then "100-110"
elseif [Total Rev] <= 120 then "110-120"
elseif [Total Rev] <= 130 then "120-130"
elseif [Total Rev] <= 140 then "130-140"
elseif [Total Rev] <= 150 then "140-150"
elseif [Total Rev] <= 160 then "150-160"
elseif [Total Rev] <= 170 then "160-170"
elseif [Total Rev] <= 180 then "170-180"
elseif [Total Rev] <= 190 then "180-190"
elseif [Total Rev] <= 200 then "190-200"
elseif [Total Rev] <= 210 then "200-210"
elseif [Total Rev] <= 250 then "210-250"
elseif [Total Rev] <= 300 then "250-300"
elseif [Total Rev] <= 400 then "300-400"
elseif [Total Rev] <= 500 then "400-500"
elseif [Total Rev] <= 750 then "500-750"
elseif [Total Rev] <= 1000 then "750-1000"
ELSE "more than 1000" ENDIF

Workflow

Common Use Cases

Accepted answers

scottj

Just noticed I was offset by one. Here is the fixed version.

Binning groups with Tile.yxmd

All comments

scottj

I would use the tile tool. In the attached example, i created all the bins and matched to the data run through a Tile tool set to manual. I even used a generate rows to create most of the manual typing for me.

Binning groups with Tile.yxmd

scottj

Just noticed I was offset by one. Here is the fixed version.

Binning groups with Tile.yxmd

Claje

Another way to do this which adds some more configuration options is to use Generate Rows and a Join tool to cover all of your Revenue cases.

I've attached a quick example using the same test data that @scottj used, with one row added for the >1000 category.

Note that this option will work really well for small numbers as in this example, but that from a performance perspective other options may be faster if we need to have multiple categories in the millions or hundreds of millions.

Claje_RevenueRangeJoin.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335