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.