Transforms

Sometimes we want to transform a value before passing it along to other events. We can do this by using a transform function. Transforms come in two types: math functions and conversions.

Math Functions

Transforms for using math functions follow the form:

=T('ceil')

This will take an inbound numeric value of 1.1 and transform it into 2.0.

A full list of available Transform functions, the input they expect, and the type of output they return:

Transform	Input	Output
`round`	Number	The number rounded; rounds up if >= 0.5, down if < 0.5.
`abs`	Number	The absolute value of the number.
`ceil`	Number	The ceiling of the number.
`floor`	Number	The floor of the number.
`log`	Number	The log of the number.
`sqrt`	Number	The square root of the number.
`float`	String	The float representation of a string.
`strings`	List	A list containing only the string elements of the list.
`numbers`	List	A list containing only the numeric elements of the list.
`count`	List	A number representing the length of the list.
`first`	List	The first element of the list.
`last`	List	The last element of the list.
`mean`	List of numbers	The average of the list.
`sum`	List of numbers	The sum of the elements of the list.
`min`	List of numbers	The smallest element of the list.
`max`	List of numbers	The largest element of the list.
`median`	List of numbers	The median of the list.
`stddev`	List of numbers	The standard deviation of the list.
`kurtosis`	List of numbers	The kurtosis of the list.
`skewness`	List of numbers	The skewness of the list.

Conversions

Transforms can also be used to convert between common units, like liters, gallons, miles, inches, yards, pints, etc. For example:

=T('liters', 'gallons')

=T('inches', 'meters')

The convention being 'from', 'to'.

A full list of all available units is beyond the scope of this guide, may be found here.