Find the X that has the most Y

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

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request



Please sign in to leave a comment.