Guide
BINS
Returns the categorical ordered intervals
BINS([Users Count], 10)
DATENAME
Returns provided date part of date as a text
DATENAME([Created On], 'year')
FIRST
Returns first met value in a set
FIRST([Name])
LAST
Returns last met value in a set
LAST([Name])
LEFT
Returns first N symbols of text
LEFT('Hulk', 2)
LOWER
Converts text to lower case.
LOWER('Hulk')
REPLACE
Replaces text to be replaced in an income text expression with its replacement
REPLACE([Name], 'Suit', 'Helmet')
RIGHT
Returns last N symbols of text
RIGHT('Hulk', 2)
SPLIT
Splits values of text field using defined delimiter.
SPLIT([Tags], ',')
TEXT
Returns provided numerical or date as a text
TEXT([Created On])
TEXT_AGG
Combines all text values into one
TEXT_AGG([Feature])
UPPER
Converts text to upper case.
UPPER('Hulk')