Convert a Measure Field Type to Dimension

When you load data into a dataset, CRM Analytics tags a dimension field as a measure if it contains only numbers. For example, CRM Analytics tags a numerical Room Number field as a measure, even though it’s actually a dimension that identifies rooms. To use dimension functionality, such as grouping and filtering by dimension fields, use the To Dimension transformation to change the measure field type to dimension.

Required Editions

User Permissions Needed
To create a recipe:	Edit Analytics Dataflows OR Edit Dataset Recipes

Note To convert a measure to a dimension in a Data Prep recipe, see Number to Text Transformation: Convert the Column Type.

1. On the column header of the measure field, click , and then select To Dimension.
   
2. Click Add and save the recipe.

Run the recipe to create a new field with the dimension field type.