Field transformations¶

Field transformations are formulas applied to fields in your result set. Examples include displaying another field if a value is missing, rounding a numeric value, counting occurrences, and summing values.

Transformation categories¶

Transformations are organized into four categories:

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

Option details¶

See the 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

Not all MySQL functionality has been implemented in the Search Kit.