Property Functions


Function

Description

$csearch

Selects a number of columns from a data table using a limiting search expression. The first argument is a data table and the second argument is a string that contains the search expression determining which column names should be returned. The function returns a list of the (unescaped) column names from the data table that match the search expression.

Examples:

$csearch([Data Table],"*")

→ Returns a list of all values in the data table called Data Table.

$csearch([Data Table], "Col*")

→ Returns a list of all values in the data table Data Table beginning with "Col", e.g., Column 1, Column 2, etc.

$esc

Replaces "]" in column names with "]]" and encloses the escaped column names in "[" and "]". The argument is a property value or a property function that starts with a dollar sign ($). See Properties in Expressions for more information.

Examples:

$esc(${PropertyName})

→ Returns the property value as a column name (within [ and ]).

$esc($csearch([Data Table], "Col*"))

→ Returns a list of all columns in the data table Data Table beginning with "Col", e.g., [Column 1], [Column 2], etc.

$map

Maps a list-valued property to a single string. The first argument is a template to use for each value in the list and the second argument is a specification of how the list values should be connected in the resulting expression. See Properties in Expressions for more information.

Examples:

$map("sum([${PropertyName}])", ",")

→ Returns a comma separated list of the sum of the columns included in the list-valued property, e.g., sum([Column 1]),sum([Column 2])

<$map("[${PropertyName}]", " NEST")>

→ Returns a nested categorical hierarchy using the columns included in the list-valued property, e.g., <[Column 1] NEST[Column 2]>

BaseRowID

Returns a unique identifier for each calculated row in the visualization. This identifier is selected from identifiers calculated on the Data Table.  This value may change when filtering or marking is performed.

Example:

BaseRowId()

ColumnProperty

The first argument is a column and the second argument is the column property name, presented as a string. Returns the value of the named column property from the column. The column property value cannot be a list and the column property has to exist before creating the expression.

Custom column properties can be specified using Edit > Column Properties, Properties tab, New-button.

Example:

ColumnProperty([Column], "Description")

DataTableProperty

Returns the value of the data table property. The argument to the method is the name of the data table property, presented as a string.

Example:

DataTableProperty("Table.CreationDate")

DocumentProperty

Returns the value of the document property. Custom document properties can be specified under Edit > Document Properties, Properties tab. Document properties can be used throughout the entire document.

The argument to the method is the name of the document property, presented as a string.

Example:

DocumentProperty("Extension.NumberOfBins")

RowID

Returns a unique identifier for each calculated row in the visualization.  This identifier will not change when filtering or marking is performed.

Example:

RowId()

See also:

Binning functions

Conversion functions

Date and Time functions

Logical functions

Math functions

OVER functions

Ranking functions

Spatial functions

Statistical functions

Text functions