Category / Section
How to change measure (Integer) values into dimension (String) type in Bold BI
Published:
Changing the column datatype is a common requirement when working with data in Bold BI. This can be achieved through column data type conversion or by creating an expression based on the datastore being used.
Column Data type Conversion:
- Navigate to the data source tab in Bold BI.
- Edit the Data source or drag and drop the data tables.
- Choose the desired data type and apply the changes.
If you are using code view mode then change the column as below and Run the query and save the data source.
The code mode casting is exclusive to PostgreSQL. You should employ the appropriate syntax according to the data source you are utilizing.
Additional References
SM
