Binning numeric fields
So far, we have been working with string-type fields, but what happens when we need to group data from numeric-type fields?
Alteryx has us covered. With the Multi-Field Binning tool, we can reproduce some of the Tile tool’s functionalities on numeric fields.
In this recipe, we will be grouping data based on its numerical values, with the help of the Multi-Field Binning tool.
Getting ready
We have prepared a dataset for you to follow along with this recipe. You can download it here: https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch6/Recipe4.
If you decide to follow along with your data, just make sure you have some quantitative data that needs to be grouped (for example, sales amounts in n groups).
How to do it…
Follow these steps:
- Drop an Input Data tool onto the canvas and point it to
..\DATA\DOCUMENTS.yxdb:
Figure 6.42: The dataset’s contents
We can see...
