Formatting Columns
Renaming column
To rename a column, double click on the respective column to enable the edit mode, and type the modified name. Press the <Enter> key to confirm the changes.
Once the column has been renamed, the modifications will be reflected in the table.
You can also rename the column by clicking on the Settings icon, which will be displayed as shown below.
Click on this icon to open a dropdown menu with the option to Rename Column. Clicking on this option will enable the edit mode for that column.
Handling column type conversion
Click on this icon to drop down the menu with the option to Change Column Type. Clicking on the Change Column Type option allows you to convert the column type.
The table below lists the column data types and their equivalent convertible types that are supported in Dashboard Designer.
| Column Data Type | Equivalent Convertible Types |
| Date | String |
| Integer | Date, String |
| String | Date |
Show Value As
Click on this icon to drop down the menu with the option Show Value As. Clicking on the Show Value As option allows you to convert the string column type into the desired string format.
The table below illustrates the Show Value As types and their corresponding transformations.
| Show Value As Type | Transformation |
| Capitalize Each Word | Converts the first character in each word to uppercase and the remaining characters to lowercase of a string column. |