For this example, I'm going to find which product size (X) has the most sales (Y).

1️⃣ Head to the summarise step in the left-hand query builder and add a new dimension. In this example the dimension will be the size, because size is my X in this example.

2️⃣ Next, I will add a new metric. This is because to find which product size (X) has the most sales (Y), I need to measure against something. In this case that something will be the quantity of products.

3️⃣ Once I click count products, a new column will appear with the quantity of sales for each size.

Giant is more popular than Super Giant and Huge - interesting! 😉