To change the "#number of employees" field to a select field:
1. Right-click on the column
2. Click "Edit Column" > "Select Data Type"
3. Choose "Select" as the data type
4. Add your dimension options
5. Click "Save Settings"
The Select data type lets you create predefined categories for company sizes (like "1-10", "11-50", "51-200", etc.).
When you get "this value could not be converted" error while changing to a Select data type, it's likely because existing values don't match your new options. Try these solutions:
1. Create a new column with the Select data type instead of converting the existing one
2. Use a formula to standardize your data first
3. Add your existing values as options in the Select field
For formula approach, use conditional statements to map current values to your desired categories.
.png){kind=logo}
