Spotfire® User Guide

Transformations preferences

Preferences that an administrator can specify for transformations.

Preference Description
Pivot preferences
DefaultAggregationForNumericType Specifies the default aggregation method to use when aggregating numeric types in the Pivot tool.

The factory default is Sum.

DefaultAggregationForOtherTypes Specifies the default aggregation method to use when aggregating other types than numeric or string in the Pivot tool.

The factory default is Count.

DefaultAggregationForStringType Specifies the default aggregation method to use when aggregating string types in the Pivot tool.

The factory default is Concatenate.

DefaultNamingExpressions

Lets you add naming patterns to the Column naming pattern list in the Pivot dialog.