Hi Team,
Currently we have a limitation in the data designer for the picklist data type fields.When ever the picklist data type fields are used in the data designer after preparing the data , The data types are automatically converted into string.Please find below screenshot
Can you please have a look at it and let us know if we have any plan in future releases to fix this so that customers can use picklist data type fields as it is with out converting the data type to string.
Use case: When user tries to uses this data designer object in the dashboard they are not able to apply the filters for the picklist data type fields along with other reports as all the fields in data designer object is of string or number type.
Let me know your thoughts