How to Edit Column Properties


Column properties are any type of metadata available for the columns (and, in some cases, also for hierarchies) in your data table. For example, this could be the name or number of decimals of a column, the data type, an optional description of the column content, or, a customized sort order for a string column. Many properties are available in the column view of the expanded Data panel.

All properties can also be viewed, and some can be edited, by selecting Edit > Column Properties.

  1. If the data panel is not already open, click data_panel_i.png.

  2. In the data panel, click the column of interest.

  3. Click the Expand data panel for tools and details button, data_expand_data_panel_for_tools_and_details_i.png.

  4. In the expanded data panel, click the edit button to the right of the column name and type the new name.

  1. If the data panel is not already open, click data_panel_i.png.

  2. In the data panel, click the column of interest.

  3. Click the Expand data panel for tools and details button, data_expand_data_panel_for_tools_and_details_i.png.

  4. Under Formatting, change the formatting to another type in the drop-down list, or click the Formatting settings button, data_panel_settings_button.png, change the settings for the category of your choice, then click OK.

  5. Comment: See Formatting Settings for more information about the various options. For example, to change the number of decimals displayed for a Real column, select Number and click on the Formatting settings button. Then change Decimals to the desired number.

  1. If the data panel is not already open, click data_panel_i.png.

  2. In the data panel, click the column of interest.

  3. Click the Expand data panel for tools and details button, data_expand_data_panel_for_tools_and_details_i.png.

  4. Under Data type, select the new data type.

  5. Comment: Note that not all data is suitable to be converted to all data types. You can always undo your choice or select a different data type if this should happen.

  6. For some types of conversions you may also need to click the Settings button, data_panel_settings_button.png, and specify additional conversion settings, to get the result that you want.


Note: In the Settings dialog, there are different conversion settings available depending on the data and data types. For example, if the column values must be rounded off in the conversion, you can specify which rounding method to use. In the case of rounding, there are three rounding methods available: Floor (nearest integer down), Ceiling (nearest integer up), and Round (halves away from 0).

Note: Custom sort order can only be applied to string columns, not to columns of other data types.

  1. If the data panel is not already open, click data_panel_i.png.

  2. In the data panel, click the column of interest.

  3. Click the Expand data panel for tools and details button, data_expand_data_panel_for_tools_and_details_i.png.

  4. Under Sort order, select Custom from the drop-down list.

  5. Click the Settings button, data_panel_settings_button.png.

    Response: The Custom Sort Order dialog is displayed.

  6. Move the values up or down in the Value order list, to create the desired sort order.

  7. Click OK to close the dialog.

  1. If the data panel is not already open, click data_panel_i.png.

  2. In the data panel, click the column of interest.

  3. Click the Expand data panel for tools and details button, data_expand_data_panel_for_tools_and_details_i.png.

  4. In the expanded data panel, click Delete column , data_delete_i.png, to the right of the column name.

  5. Comment: You can hide columns from separate visualizations using the appropriate page in the Visualization Properties dialog without actually deleting the column. Likewise, you can hide filters that you do not wish to use in the Organize Filters dialog.

  1. If the data panel is not already open, click data_panel_i.png.

  2. In the data panel, click the calculated column of interest.

  3. Click the Expand data panel for tools and details button, data_expand_data_panel_for_tools_and_details_i.png.

  4. In the expanded data panel, under Expression, click Edit.

  5. Comment: For information about how to write expressions for calculated columns, see General Syntax, and the related topics.

It is possible to display the text in a table as clickable hyperlinks by setting the renderer for a column to Link Renderer. Setting a template in Column Properties provides a default suggestion for the Link Renderer. The default template is "http://{$}/", where {$} represents the value from the table cell.

  1. Select Edit > Column Properties.

  2. If you have more than one data table in the document, select the Data table to work on.

  3. Locate the column of interest by scrolling in the list or by typing a search expression in the field provided.

  4. Click to select the column.

  5. On the Column Properties tab, scroll down to locate the Link Template property and click to select it.

  6. Click Edit Value....

    Response: The Edit Value dialog is displayed.

  7. Type a new template for the format of the links.

    Comment: For example, "http://www.{$}.com".

  8. Click OK to close the Edit Value dialog.

  9. Click OK.

See also:

Details on Column Properties - General

Details on Column Properties - Formatting

Details on Column Properties - Properties

Details on Column Properties - Sort Order