Custom Column when Creating a Metric

When creating a custom metric, is there a way to create a custom column similar to the query builder?

For example, to calculate Net Revenue, I use the following in SQL:

Net Revenue = SUM(order_amount) - SUM(discount_amount) - SUM(tax_amount)

It seems it is not possible to write this kind of expression in the custom metric builder, only to aggregate one column like SUM(order_amount).

Hi @pjhaberman
Without knowing which version of Metabase you're using, then I'm guessing you're seeing this issue:
https://github.com/metabase/metabase/issues/22700 - upvote by clicking :+1: on the first post

1 Like