Skip to content

Home > User Guide > Searching and reporting > Search Kit

Field Transformations

Field transformations are "formulas" you apply to fields in your result set. e.g. displaying another field if a value is missing, rounding a numeric value, counting occurences, summing values, etc.

Description

The list of transformations is organized in 4 categories:

  • Comparison
  • Text
  • Math
  • Aggregate (only available if you used Group By)

Option Details

See MySQL documentation for more information:

  • https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
  • https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html

Please note that not all of the MySQL functionality has been implemented in the Search Kit.