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.

Picture: Elnur/Adobe Inventory

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

Including Producers and Gross sales to the right cabinets.

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

Determine B

Creating a brand new parameter for the High N filter.

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

Configuring the brand new parameter.

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

Determine D

Our filter is able to edit.

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

Configuring our new filter.

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

Determine F

It’s time to indicate our High N parameter.

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

You may change the sphere by transferring the slider to the fitting or left to indicate extra outcomes.

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.

Keep linked with us on social media platform for on the spot replace click on right here to affix our  Twitter, & Fb

We at the moment are on Telegram. Click on right here to affix our channel (@TechiUpdate) and keep up to date with the newest Expertise headlines.

For all the newest Expertise Information Click on Right here 

 For the newest information and updates, observe us on Google Information

Learn unique article right here

Denial of duty! NewsAzi is an computerized aggregator across the world media. All of the content material can be found free on Web. We’ve simply organized it in a single platform for instructional objective solely. In every content material, the hyperlink to the first supply is specified. All emblems belong to their rightful house owners, all supplies to their authors. In case you are the proprietor of the content material and don’t want us to publish your supplies on our web site, please contact us by electronic mail – [email protected]. The content material will likely be deleted inside 24 hours.