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!