---
schema_version: "1"
id: 8f09e4767fd75635002b1e36dd0f62f9f1e54fbbee65e03ae38077133c84ee4a
title: Categorize Measure Column Values into Buckets
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_transformation_bucket_measure.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_bucket_measure.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 37ef87ad2d15af40f6b6bf06ea345090142e07f99afe9779e88203f90fda15c5
description: In CRM Analytics, use a bucket column in a Data Prep recipe to categorize and organize numeric values. For example, you can create buckets High, Middle, Low to group numbers of cases per account.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Categorize Measure Column Values into Buckets

In CRM Analytics, use a bucket column in a Data Prep recipe to categorize and organize numeric values. For example, you can create buckets High, Middle, Low to group numbers of cases per account.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
          <colgroup>
            <col style="width:50%">
            <col style="width:50%">
          </colgroup>
          <thead class="slds-text-title_caps ">
            <tr class="">
              <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d122072e38">User Permissions
                Needed</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d122072e38 ">To manage and create a recipe:</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d122072e38 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>

            </tr>
          </tbody>
        </table>

1. In the Transform node of a Data Prep recipe, select the number (measure) column in the Preview tab.
2. In the Transform toolbar, click the Bucket button (![Create bucket button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_data_prep_bucket_icon.png)) to define the buckets.
    
    ![The left panel provides options to set the buckets.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_bucket_measures_edit.png)
3. For Range 1, enter a value and label for the first bucket. Rows with values below the Range 1 value are assigned to this bucket. ![The Define Range modal is where you specify the bucket label and range.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_bucket_define_mea_bucket.png)
4. If your bucket column has more than two buckets, click **Add Range>>** to add a middle range.
5. For each additional middle range you add, enter the range of values and the bucket label.
    
    Rows with values greater than or equal to the first value and less than the second value are assigned this bucket.
6. For the final range, enter a value and bucket label. Rows with values greater than or equal to this value are assigned to this bucket.
    
    ![The defined ranges appear in the Bucket modal.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_bucket_define_mea_ranges.png)
7. To place null values into their own bucket, select **Bucket null values**.
8. Under Show Results In, select whether the buckets appear in a new column and what happens to the original column.
9. If you elect to create a column, set the label under Column Label.
10. Click **Apply** to add the transformation to the Transform node. The Preview tab shows the new bucket column.
11. To view the Graph area, click the Collapse button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_button_collapse.png)).
12. Save the recipe.

After you run the recipe, you can view the bucket assigned to each row in the bucket column.