TIBCO Cloud™ Spotfire® Web Client User Guide

Visualization properties in expressions

In some cases, you might want to use the expression or the display name currently set on an axis as a dynamic part of another expression, so that it changes with your selections. For example, this can be interesting in a visualization title or in a tooltip or label. You might also want one axis to be automatically configured to use the same expression as the one set on another axis. For example, you might want the color axis to automatically update to the same expression as what is used on a categorical axis.

There are a number of different "axis expressions working like properties" available in the visualizations. These properties exist only in the context of a visualization and they have values that are defined by the currently used settings in the visualization. For example, a scatter plot can expose the display name of its X and Y-axis expressions as properties and these can in turn be used to specify the visualization title.

The syntax to use is ${Axis.Axis Name.DisplayName}, ${Axis.Axis Name.ShortDisplayName} and ${Axis.Axis Name.Expression}, for the display name, short display name and the underlying expression, respectively. For example, if the Axis Name is "X", the expression could refer to ${Axis.X.DisplayName}, ${Axis.X.ShortDisplayName}, or ${Axis.X.Expression}. Note that the actual axis names to use can be different in two similar looking visualizations, see below. The ${DataTable.DisplayName} property can be used in all visualizations to retrieve the name of the main data table used in the visualization.

These properties can be used the same way as other types of properties. See Properties in expressions for more information. All of the display name-properties listed below also have a corresponding property for the actual expression.

Visualization Axis name used in expression Axis (property) it represents
[All visualizations] DataTable.DisplayName The name of the main data table used in the visualization
Cross table Axis.Columns

Axis.Measures

Axis.Rows

Horizontal axis

Cell values

Vertical axis

Graphical table Axis.Rows Graphical table rows
Bar chart Axis.Color

Axis.Columns

Axis.Pages

Axis.Panels

Axis.Rows

Axis.X

Axis.Y

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

Category axis

Value axis

Waterfall chart Axis.Color

Axis.Columns

Axis.Pages

Axis.Panels

Axis.Rows

Axis.X

Axis.Y

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

Category axis

Value axis

Line chart Axis.Line

Axis.Color

Axis.Columns

Axis.Pages

Axis.Panels

Axis.Rows

Axis.X

Axis.Y

Line by

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

X-axis

Y-axis

Combination chart Axis.Color

Axis.Columns

Axis.Pages

Axis.Panels

Axis.Rows

Axis.X

Axis.Y

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

X-axis

Y-axis

Pie chart Axis.Color

Axis.Columns

Axis.Pages

Axis.Panels

Axis.Rows

Axis.Size

InnerAxis.Color

InnerAxis.SectorSize

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

Pie size by

Color by

Sector size by

Scatter plot Axis.Color

Axis.Columns

Axis.DrawingOrder

Axis.Line

Axis.Marker

Axis.Order

Axis.Pages

Axis.Panels

Axis.Rotation

Axis.Rows

Axis.Shape

Axis.Size

Axis.X

Axis.Y

InnerAxis.Color

InnerAxis.SectorSize

Color by

Trellis columns

Drawing order by

Connect by (draw a separate line per value in)

Marker by

Order by (order each line by)

Trellis pages

Trellis panels

Rotation by

Trellis rows

Shape by

Size by

X-axis

Y-axis

Pie sector color

Pie sector size

3D scatter plot Axis.Color

Axis.Columns

Axis.Marker

Axis.Pages

Axis.Panels

Axis.Rows

Axis.Size

Axis.X

Axis.Y

Axix.Z

Color by

Trellis columns

Marker by

Trellis pages

Trellis panels

Trellis rows

Marker size by

X-axis

Y-axis

Z-axis

Map chart - Feature layer Axis.Color

Axis.Columns

Axis.Geometry

Axis.Pages

Axis.Panels

Axis.Rows

Color by

Trellis columns

Feature by

Trellis pages

Trellis panels

Trellis rows

Map chart - Marker layer Axis.Color

Axis.Columns

Axis.DrawingOrder

Axis.Line

Axis.Marker

Axis.Order

Axis.Pages

Axis.Panels

Axis.Rotation

Axis.Rows

Axis.Shape

Axis.Size

Axis.X

Axis.Y

InnerAxis.Color

InnerAxis.SectorSize

Color by

Trellis columns

Drawing order by

Connect by (draw a separate line per value in)

Marker by

Order by (order each line by)

Trellis pages

Trellis panels

Trellis rows

Rotation by

Shape by

Marker size by

X-axis

Y-axis

Pie sector color

Pie sector size

Treemap Axis.Color

Axis.Columns

Axis.Pages

Axis.Panels

Axis.Rows

Axis.Size

Axis.Hierarchy

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

Size by

Hierarchy

Heat map Axis.Columns

Axis.Pages

Axis.Panels

Axis.Rows

Axis.X

Axis.Y

Axis.Measures

Trellis columns

Trellis pages

Trellis panels

Trellis rows

X-axis

Y-axis

Cell values

KPI chart Axis.Color

Axis.Comparative

Axis.Tile

Axis.X

Axis.Y

Color by

Comparative value

Tile by

X-axis

Y-axis

Parallel coordinate plot Axis.Line Line by
Summary table Axis.CategoryAxis Categorization
Box plot Axis.Color

Axis.Columns

Axis.Pages

Axis.Panels

Axis.Rows

Axis.X

Axis.Y

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

X-axis

Y-axis