---
schema_version: "1"
id: fc8ea0152c84b2eaa44d364edabbf513906da742e37099be1d2a30f64c06da05
title: Bucket a Dimension 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_dim.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_recipe_bucket_dim.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 78af013b0c9952b2e8f1126cfd2752305d5a252ac06cc9a9a9b268f971b3773c
description: Add a field to a recipe to bucket values in a specified dimension field.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Bucket a Dimension Field in a Recipe

Add a field to a recipe to bucket values in a specified dimension 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="d77041e47">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d77041e47 ">To create a recipe:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d77041e47 ">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 dimension values in a Data Prep recipe, see [Categorize Dimension Column Values into Buckets](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_bucket_dimension.htm&release=264.0.0&type=5 "In CRM Analytics, use a bucket column in a Data Prep recipe to categorize and organize text values. For example, you can create buckets West, Central, and East to group regions.").

A bucket field lets you create new values based on existing values in another field. For example, use a bucket field to categorize products in support cases according to their type.

 
| Product | Product Category |
| --- | --- |
| HVAC Ctrl, HeatWave, Home A/C | HVAC |
| Humidity Ctrl, Humidity Unit, Home Humidity | Humidity |
| Compressor, Condenser, Thermostat | Parts |

1. On the column header of the dimension 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.
    
    ![Dimension 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_dimension.png)
2. In the Bucket1 field, enter a name for the first bucket.
3. In the **Values for...**box, enter the values to be assigned to this bucket. Press Tab after each value to enter the next.
    
    In this example, rows containing HVAC Ctrl, HeatWave, or Home A/C product values are assigned a value of HVAC in the new bucket field.
    
    ![Dimension bucket 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_dim_bucket1.png)
4. To add more buckets, click ![Add 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_integrate_data_prep_recipe_add_filter_condition_button.png) and repeat steps 2–3.
5. To bucket remaining values that you have not bucketed, select **Bucket remaining values** and enter a bucket for these values.
    
    If you don’t select this option, rows with unbucketed values keep the same value in the new bucket field.
6. When you have completed all the buckets, click **Add**.
    
    The new bucket field appears next to the source field in the recipe preview.
    
    ![Dimension 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_dim_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.