Column Element Tab


Option

Description

Add >

Select a column from the Data Sources tree and click on this button to include it in the new column.

< Remove

Deletes the selected column from the composition.

Source columns

Lists all source columns that will be included in the calculation of the new column element.

Expression

To perform any calculation on the column, enter the expression in this text field.

Data type

Specifies the data type of the column.

 

Option

Description

Description

An optional description of the column element.

 

 

Option

Description

Add >

Select a column from the Data Sources tree and click on this button to include it in the filter.

< Remove

Removes the selected column from the composition.

Expression

In this field, enter an expression containing the selected column or columns.

 

The Group by section is only important if you have specified some type of aggregation in the Expression field at the top of the page. When an aggregation has been defined, you can select the categories to group by here. See Using Aggregation in Information Designer for more information.

Option

Description

Group by expressions

Lists the group by expressions specified using the source columns selected under Settings and any calculations done in the Expression field.

New

Adds a new, empty expression to the Group by expressions list.

Delete

Deletes the selected expression from the Group by expressions list.

Add >

Adds the columns selected in the Data Sources tree to the Source columns list, where it can be used in a group by expression.

< Remove

Deletes the selected column from the Source columns list.

Source columns

Lists the columns that are to be used in the expression determining what to group by.

Expression

Enter an expression here to define what  to group by.

Drillable

Select the check box if you want the column to group by all other columns that are included together with this column element in an information link. See Using Drillable for more information.

 

Option

Description

Property name

Shows the names of custom properties defined for this column. Custom properties are metadata that can be used when searching for columns using the following search syntax: <Property name>:<Value>. For example, MyCompany.Property:Property1.

Some types of data require specific properties and values to be treated correctly by Spotfire. An example is map columns which require the property mapchart.columntypeid, with the Value Geometry, XMax, XMin, YMax, YMin, XCenter or YCenter set on the different kinds of columns used when viewing WKB data in a map chart. See Configuration of Geographical Data for Map Charts for more information.

Another example is chemical structure data, which requires the ContentType property to be set to chemical/x-mdl-molfile for the structure column and a "LeadDiscovery.Column" property with particular values defined for ID columns and search columns.

Custom column properties can also be used for drawing lines in some of the visualizations.

Value

Shows the value of each custom property.

Add...

Opens the Add Column Property dialog where custom properties can be defined.

Edit...

Opens the Edit Column Property dialog.

Delete

Deletes the selected property.

See also:

Creating a Column Element

Data Sources Tree