Tricks for filtering dimensions that you're pivoting on

[conor (Conor O'Mara)]

Here’s a neat workflow to get the limit your pivot to the top 20 values. In this example I’ll work with eCommerce product data and use Omni’s filter by query feature.

1. First off, we’ll make a tab called Top 20 Products and get the product name dimension and order by Sale Price Sum. We’ll set the limit to 20 so that we are getting the Top 20.
   

   

2. In a second tab, we’ll add a filter on Products Name and select is from another query. We can then select from the Top 20 Products tab query on the Product Name field.
   

   

3. Then we’ll add Created At Month, pivot by Product Name and now we’ll a monthly pivot of our top 20 products and we’ve got what we wanted nice and quick!
   

   

Extra notes

This is really useful for cohort analysis.

We can also go further an filter on multiple queries too.

You can view the demo of Filter by Query here.