Aggregate Columns

Another user is trying to evaluate transactions by country. Lists of transactions are a start, but they really want to see some totals for comparison. In the transactions table, you use bipp to add an amount column to aggregate the totals using the invoice_qnty and unit_price columns.

aggregate columns bipp

Select your columns:

aggregate columns columns

bipp generates the SQL:

SELECT t000.country AS _0,
    sum(t000.invoice_qnty*t000.unit_price) AS _1
FROM `online_retail`.`transactions` AS t000
GROUP BY 1

Fetch the data:

aggregate columns results

Select a chart to make it easier for your user to see the relationships:

aggregate columns pie

IN THIS PAGE