View the original community article here
Last tested; Jun 4, 2021
LEXP stands for Looker Expressions. It is a special syntax created by Looker that is used for Table Calculations, Custom Fields, and Custom Filters. We have a doc that outlines the general usage of expressions, and another doc that has a list of all functions that it currently supports.
Why do I need to know this?
The value here is to know that the overlap exists between Table Calculations, Custom Fields, and Custom Filters. Not all functions are available in all 3 locations, but many are.
- For example, once you learn a new Table Calc, you can most likely apply it to a Custom Filter or Custom Field as well!
- For example, if you encounter an issue in Custom Fields, then you should consider that the bug may affect Table Calculations as well!