Custom Columns

Custom expressions are formulas you can write in the built-in query builder to perform calculations, apply conditional logic, or build filters that go beyond the standard options. If you've used formulas in Excel or Google Sheets, the concept is the same: you combine functions, operators, and column references to produce a value.

Custom expressions can be used in three places:

• Custom Columns: to create a new column calculated from existing ones
• Custom Filters: to filter rows using conditions that the standard filter options don't support
• Custom Summations: to aggregate data using calculations like conditional sums

This article focuses on creating Custom Columns.

To create a custom column, click on the Editor button while viewing a saved question (report):

On the editor screen, click Custom Column:

This opens the custom expression window. From here, enter your formula, then enter a name for the resulting custom column, and click Done:

Example: Creating a single "Full Name" column by concatenating the "Given Name" and "Family Name" columns

The resulting "Full Name" column when viewing the report:

Example: Creating an "Age" column by calculating the difference between an individual's birth date and the current date

The resulting "Age" column when viewing the report:

Tip: while writing a custom expression, click the small f button to open the function browser, where you can explore all available functions and see how each one works:

Wicket's reporting solution is powered by Metabase. Additional documentation is available in the Metabase documentation.