---
schema_version: "1"
id: 685b5678fa90040990e0ec9042a1616e48c5c3dd6b4f1e5b1a7c70e9c69be378
title: Categorize Date 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_date.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_bucket_date.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: cd30f4aa2148e8beb7d83b22ad04c17b956e3fa935c4190f044d673ae56fdc5e
description: 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.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Categorize Date Column Values into Buckets

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.

### Required Editions

## Categorize Date Column Values into Buckets

<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="d124347e39">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d124347e39 ">To manage and create a recipe:</td>

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

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

1. In the Transform node of a Data Prep recipe, select the date 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.
3. Select whether to use absolute or relative dates.
    
    Absolute dates are defined dates on a calendar, like July 25, 2023. Relative dates are a time period in relation to the day the data is viewed, like last quarter, or next month.
    
    ![The left pane shows options to configure the date 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_dates_edit.png)
4. Select ![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).
5. Enter a label for the first bucket.
    
    The first bucket is for the earliest date range. Each subsequent bucket must have a later date range than the previous bucket.
    
    ![The Define Range modal allows you to specify a bucket label and its 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_dates_define_bucket.png)
6. Select the date range for this bucket.
7. Click **Add**.
8. To create another bucket with a later date range, 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 specify the details.
9. To place null values into their own bucket, select **Bucket null values**.
10. Under Show Results In, select whether the new bucket values appear in a new column and what happens to the original column.
11. If you elect to create a column, set its label under Column Label.
12. Click **Apply** to add the transformation to the Transform node. The Preview tab shows the new bucket column.
13. 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)).
14. Save the recipe.

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