---
schema_version: "1"
id: f0e997409f94f4bd46f521d229da45020be399460ea9d690b00bb046d34f3063
title: "Bucket Transformations: Categorize Column Values"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_transformations_bucket.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformations_bucket.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 09467c449e426232210bf22088918c64b0106b0929ad98e07a63d3dab4782743
description: With CRM Analytics Data Prep, you can bucket your numbers, text, and date fields to group and organize data.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Bucket Transformations: Categorize Column Values

With CRM Analytics Data Prep, you can bucket your numbers, text, and date fields to group and organize data.

- **[Categorize Date Column Values into Buckets](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_bucket_date.htm&release=264.0.0&type=5)**  
    In CRM Analytics, Data Prep provides transformations that allow you to prepare, clean, and transform your data. For example, you can use a transformation to create a calculated column based on a formula. You add transformations inside a Transform node. You can string together multiple transformations to manipulate data sequentially.
- **[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.
- **[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.