community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Tools to classify/Group/Bin values

Highlighted
Atom

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

 

Alteryx
Alteryx

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.

Scott Jones
Strategic Sales Engineer
Alteryx, Inc.
Alteryx
Alteryx

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

Scott Jones
Strategic Sales Engineer
Alteryx, Inc.
Magnetar
Magnetar

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.

Atom

Thanks for your solution. I found the way you used the binning tool really insightful. 

Labels