What is a custom expression?
A custom expression in Metabase is a formula that uses functions and mathematical operators to allow for more complicated questions, similar to a formula in spreadsheet software. You can include custom expressions in questions asked via Metabase’s query builder.
Custom expressions give those GUI questions more power and flexibility, without requiring you to write a full SQL query. You can write custom expressions to create custom columns, or to create more advanced filters and aggregations.
Example custom expression in Metabase
The example below shows the creation of a custom column that categorizes
Orders according to their
Subtotal using the case function.
Figure 2 shows the resulting table, with our new custom column on the right:
- Custom expressions in the notebook editor
- Docs on using custom expressions
- List of expressions in Metabase
Did this article help you?
Thanks for your feedback!