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).