Skip to content

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.


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:


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