Text calculations

Returns the categorical ordered intervals

BINS([Users Count], 10)

Returns provided date part of date as a text

DATENAME([Created On], 'year')

Returns first met value in a set

FIRST([Name])

Returns last met value in a set

LAST([Name])

Returns first N symbols of text

LEFT('Hulk', 2)

Converts text to lower case.

LOWER('Hulk')

Replaces text to be replaced in an income text expression with its replacement

REPLACE([Name], 'Suit', 'Helmet')

Returns last N symbols of text

RIGHT('Hulk', 2)

Splits values of text field using defined delimiter.

SPLIT([Tags], ',')

Returns provided numerical or date as a text

TEXT([Created On])

Combines all text values into one

TEXT_AGG([Feature])

Converts text to upper case.

UPPER('Hulk')