More than 2 columns with aggregations

Hi Metabase!

First of all - Thanks for creating such a fantastic tool! Doing Science is totally a winner!

My questions is, why is there a limit of 2 columns when aggregating the results?

Considering a table that is composed of (columns):
seller
product_id
price
Product_shape
delivery_zone
no_of_checkouts

In SQL I would say:
SELECT

  • seller,
  • delivery_zone,
  • COUNT(product_id) as no_of_products,
  • SUM(no_of_checkotus*price) as revenue
    FROM my_table
    GROUP BY
  • seller, delivery_zone

However in the console, I am only allowed to have 2 columns, and single aggregation, so I either select all the results limited by where clause, or create a group of single metrics.

Are there any plans to add this functionality in future, or is there a way to enable this sort of logic?

Thanks!

The gui tool is optimized for quick reports and the ability for nontechnical people to ask their own questions.

We’re working on ways to do what you’re describing but the main bottleneck is the UX. We’ve had a couple prototypes that did what you’re describing but they never really felt right. We’ll get there soon though =)