Skip to content
Infoveave Help

BINNING

The BINNING in Infoveave categorizes data into discrete categories or “bins”.

Applicable to

Calculated Columns

Return Value

BINNING returns the specified value if the condition is true.

Remark

BINNING can be used as a more concise alternative to IF statements for simple conditional logic.

Binning

  1. Select the data type option as BINNING.
  2. With BINNING selected as the data type, select the column required from the drop option to be put into bins/categories.
  3. Under the formula section, enter the lower and upper ranges of the values along with the bin name.
  4. Enter the bin name for the out of ranges values.
  5. To add more conditions, click on the Add Rule + option associated with the operation.
  6. Click on the execute button to run the analysis.

Binning operation

Example 1

Objective Consider you want to create an age bucket on the below table.

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITY
2024-01-03BrazilBaby Food38.4143.78742
2024-01-07JapanSpices45.5650.815520
Japan43.787410
2024-01-1832.30194
2024-01-22BrazilCosmetics28.33523.01097
2024-01-26Canada20.18523.01099
2024-01-04FranceCereal25.2628.79649
2024-01-09BrazilCereal44.57550.81558
2024-01-14BrazilSnacks20.1854
BrazilCosmetics40.48546.15292

The BINNING operation will give you the below results

The new calculated column “Age Bracket” will return

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITYAGE BRACKET
03-01-2024BrazilBaby Food38.4143.78742Medium Price
07-01-2024JapanSpices45.5650.815520High Price
Japan43.787410Low Price
18-01-202432.30194Low Price
22-01-2024BrazilCosmetics28.33523.01097Low Price
26-01-2024Canada20.18523.01099Low Price
04-01-2024FranceCereal25.2628.79649Low Price
09-01-2024BrazilCereal44.57550.81558High Price
14-01-2024BrazilSnacks20.1854Low Price
BrazilCosmetics40.48546.15292High Price