Details on Column Properties – Properties

Option

Description

Data table

Only available when more than one data table is available in the analysis. Specifies the data table that you are currently viewing column properties for.

Columns and hierarchies

Lists all columns and hierarchies available in the data table. You can narrow down the list of available columns by typing a part of a name in the "Type to search" field. You can also enter an expression in the field, using the rules described on the Searching in TIBCO Spotfire page.

Insert

     Calculated Column

Opens the Insert Calculated Column dialog, where you can create a new column from an expression.

     Binned Column

Opens the Insert Binned Column dialog, where you can group the values of a column into a smaller number of bins (groups).

     Hierarchy

Opens the Insert Hierarchy dialog, where you can create a hierarchy (an ordered structure) by combining columns with each other.

Delete

Removes the selected column or hierarchy from the data table.

Option

Description

Property Name

Lists all properties currently available for the selected column. If you have defined custom properties for the column, these properties are also listed here.

Value

Lists the value of each property for the selected column (when applicable).

New...

Opens the New Property dialog, where custom column properties can be defined. Custom column properties are added to all columns in the analysis, including those in other data tables.

Edit...

Opens the Edit Property dialog, where the value and the default value of a custom column property can be edited.

Note: If other settings than the value or the default value are wrong, you need to delete the custom property and create a new one instead.

Delete

Deletes the selected custom property. The custom column property is deleted from all columns in the analysis.