Details on Select Columns


Use this dialog when you need to select more than a few columns simultaneously from a column selector, either on an axis of a visualization, in the legend, or in a dialog.

  1. Right-click on the column selector of interest to open the drop-down list.

  2. Click on Select Columns....

vis_select_columns_d.png

(In places where you are only allowed to specify a single column the Add > button will be replaced by a Set > button and no Move Up/Move Down buttons will be available.)

Option

Description

Data table

Only available when more than one data table is available in the analysis. Allows you to select columns from other data tables than the main data table. Select a data table to view the available columns in that data table.

Available columns

Lists all columns and hierarchies available for selection.

[Type to search]

Type a search string to limit the number of items in the Available columns list. It is possible to use the wildcard character * in the search. See Searching in TIBCO Spotfire for more information.

Selected columns

Lists the columns selected to be used in this particular location, as well as the selected aggregation method used on each column (if any aggregation has been specified). Click on a column in this list to display additional settings for that column.

The name of the data table will be displayed in gray after the column name if the column originates from a data table that is not the main data table in the visualization,

Add >

Adds the columns selected in the Available columns list to the Selected columns list.

< Remove

Removes the selected columns from the Selected columns list.

Remove All

Removes all columns from the Selected columns list.

Move Up

Moves the selected column up in the Selected columns list. The order of the columns in this list determines the order of the hierarchy.

Move Down

Moves the selected column down in the Selected columns list. The order of the columns in this list determines the order of the hierarchy.

Aggregation

Click on one or more columns in the Selected columns list to make this option available. Specifies the aggregation method to use for the selected column.

Auto-bin column

Click on one or more columns in the Selected columns list to make this option available. Select this check box to temporarily bin a continuous column and create an Auto-bin slider.

Note: To create a new column with binned values, see How to Use Binning instead.

Number of bins

Specifies the starting number of bins to use in the binning. This number can be changed by dragging the auto-bin slider in the visualization (if the column selectors of all included columns fits in the window).

Level

vis_level_slider.png

Click on a hierarchy in the Selected columns list to make this option available. Specifies which level of the hierarchy to use.

See also:

Column Selectors

Drag-and-Drop