# Transforms

These events transform values and lists of values using math functions.

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.

Updated 5 months ago