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
  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
  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
  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.