How to convert a calculated field (Data type - Number) into a dimension

Trying to convert a calculated field which is a whole number into a dimension. I used tostring() function in the calculation to achieve that but Quick Sight is throwing error saying “We can’t parse this SQL syntax”. Can anyone help. Thank you

@Saty, you can convert numeric column to a dimension from the field list in analysis as shown below, hover over the field to see the three dots menu and then select convert to dimension and you can then use this field as group by column in your field wells.


convert a numeric column to dimension

Thank you for your response. For my calculated field “Covert to dimension” option is greyed out.

@Saty, can you share your calculated field definition. Thanks