Data Panel Pop-up Menu


Right-click in the data panel to bring up the pop-up menu. You will have access to different options depending on where in the data panel you click.

Data Tables

Option

Description

Rename...

Allows you to change the name of the selected data table.

Set as Default Data Table

Sets the selected data table to be the default data table in the analysis.

Data Table Properties

Opens the Data Table Properties dialog where you can edit the properties of the data tables in the analysis. Here, you can add regular relations between the data tables in Spotfire, internal as well as external, which allow you to use details visualizations and propagate marking and filtering between the data tables.

Columns

Option

Description

Rename...

Allows you to change the name of the selected column.

Note: The columns use the same name as their corresponding filters, so renaming a column will also change the filter name, if a filter exists for the column.

Delete

[Only available for in-memory data tables.]

Deletes the selected columns from the data table.

Create Filter

[Only available for columns which currently do not have a corresponding filter.]

Creates filters for the selected columns.

Note: When working with cube data it is not possible to create filters for measures or sets, only for dimension columns.

Sort

 

   Categorized

Groups the columns into different categories, Numbers, Time or Categories, which may help you setting up your visualizations properly.

   No Sorting

Applies the sorting from the original database to the columns in the list.

   Ascending

Applies an alphabetical sorting of the columns in the list.

   Descending

Applies a reversed alphabetical sorting of the columns in the list.

Column Properties

Opens the Column Properties dialog where you can edit the properties of the columns in the analysis.

Geocoding

Allows you to find a geocoding hierarchy in the library and manually specify that a column should be used for geocoding at a certain hierarchy level.

For example, if a column contains state names you can use this menu to specify that this column actually contains US states. Use the tooltip to see some example data of a certain type of encoding to find the correct match.

This information can then be used to place data at its correct location in a map chart.

When a selection is done in the menu, the column properties specifying the GeocodingType, GeocodingRepresentation and GeocodingHierarchyName are automatically set.

If you know that a column contains Longitude or X-coordinates, then select the Longitude / X option, etc. You can also click on Auto-match to make Spotfire attempt to match the content of the column to an existing geocoding hierarchy in the library.

See also:

What is the Data panel?