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.