The right way to create or use a High N filter in Tableau

Jack Wallen exhibits you tips on how to create a High N filter in Tableau, so you’ll be able to simply filter your merchandise (or any information level) by the “prime N” positions.

A High N filter returns information based on a quantity you assign it — therefore the “N” within the identify. For instance, you’ve 1,000 merchandise that your organization sells and also you need to view solely the highest 5 merchandise: For that, you’d use a High N filter.

SEE: Analysis: Digital transformation initiatives deal with collaboration (TechRepublic Premium)

Tableau helps High N filters, however they could be a bit difficult to create. I’m going to indicate you tips on how to do exactly that through the Tableau Desktop App utilizing the Superstore pattern information.

What you’ll want

To make this work, you’ll want a Tableau account, the Superstore pattern information added, and the Tableau Desktop App put in.

The right way to create the High N filter

Are you prepared? This isn’t fairly intuitive, so maintain on to your seats.

Open the Tableau Desktop app after which hook up with the Superstore pattern information. When you’ve performed that, increase the entries within the left pane till you see Producer. Drag Producer to the Rows shelf after which drag Gross sales to the Columns shelf (Determine A).

Determine A

Within the Knowledge tab within the left pane, click on the drop-down after which choose Create Parameter (Determine B).

Determine B

Identify the brand new parameter High N. Beneath Allowable values, click on Vary after which choose the checkboxes for Minimal and Most (Determine C).

Determine C

Click on OK. Subsequent, on the Rows shelf, right-click on Producer and choose Edit Filter (Determine D).

Determine D

Within the ensuing window (Determine E), click on the High tab. Choose By Subject after which, within the second drop-down, choose “High N.” Be certain Gross sales and Sum are chosen within the different drop-downs and click on OK.

Determine E

Again within the Knowledge pane (far left pane), underneath Parameters, right-click on High N and choose Present Parameter (Determine F).

Determine F

When you’ve performed this, it’s best to see a High N slider within the higher proper nook of the view (Determine G).

Determine G

Congratulations, you simply created your first High N filter in Tableau! Your information is now a lot simpler to filter by prime merchandise, companies and gross sales.

Subscribe to TechRepublic’s How To Make Tech Work on YouTube for all the newest tech recommendation for enterprise execs from Jack Wallen.