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! 😉