---
schema_version: "1"
id: f5bb2f6628a929214b5828f7a32fb64a2ed4f7f46b6b2bce32ed59c741b7ab37
title: Bucket a Measure Field in a Recipe
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_data_prep_recipe_bucket.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_bucket.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 8b011b530896aa275c01438a6b40bd3beb43ff1b21344836494feedd13d3f29d
description: Add a field to a recipe to bucket values in a specified measure field.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Bucket a Measure Field in a Recipe

Add a field to a recipe to bucket values in a specified measure field.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in Salesforce Classic and Lightning Experience.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available with CRM Analytics, which is available for an extra cost in <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions. Also available in <strong>Developer</strong> Edition.</td></tr></tbody></table>

<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="d160992e47">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d160992e47 ">To create a recipe:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d160992e47 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>
          </tr>
        </tbody>
      </table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note To bucket numeric values in a Data Prep recipe, see [Categorize Measure Column Values into Buckets](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_bucket_measure.htm&release=264.0.0&type=5 "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.").

A bucket field lets you create new values based on existing values in another field. For example, use a bucket field to categorize households as small, medium, or large, based on the number of people in the household.

 
| No. of People in Household | Size Category |
| --- | --- |
| 1–2 | Small |
| 3–5 | Medium |
| 6 or more | Large |

1. On the column header of the measure field you want to bucket, click ![Column menu 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_integrate_replication_actions_button.png), and then select **Bucket**.
    
    Bucket settings appear in the Add Transformation panel below the preview data.
    
    ![Measure bucket dialog](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_bucket_measure.png)
2. For Range1, enter a value and name for the first bucket. Rows with values below the Range1 value are assigned this bucket name. In this example, rows with values less than 3 are assigned a value of Small in the new bucket field.
    
    ![Measure bucket range 1](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_bucket_measure_range1.png)
    
    The Range2 value populates with the value you enter for Range1.
3. If your bucket field has more than two buckets, click **Add>>** to add another range.
4. For each additional range you add, enter the range of values and the bucket name. Rows with values greater than or equal to the first value, and less than the second value are assigned the bucket name. In this example, rows with values 3, 4, or 5 are assigned a value of Medium in the new bucket field.
    
    ![Measure bucket range 2](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_bucket_measure_range2.png)
5. Repeat steps 4–5 to add any additional buckets that you need.
6. For the final range, enter a value and bucket name. Rows with values greater than or equal to this value are assigned this bucket name. In this example, rows with values greater than or equal to 6 are assigned a value of Large in the new bucket field.
    
    ![Measure bucket range 3](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_bucket_measure_range3.png)
7. When you have completed all the ranges, click **Add**.
    
    The new bucket field appears next to the source field in the recipe preview.
    
    ![Measure bucket field](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_data_prep_recipe_bucket_measure_result.png)

![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_tip.png)

Tip You can use a bucket field to filter rows in a recipe.