Tools to classify/Group/Bin values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your solution. I found the way you used the binning tool really insightful.
