How to create or use a Top N filter in Tableau

Jack Wallen exhibits you similar to construct a Prime N snakehead in Tableau, to test you possibly can simply snakehead your merchandise (or any knowledge level) by the “prime N” positions.

Data monetization concept with funnel and businessmanPicture: Elnur/Adobe Inventory

A Prime N snakehead returns knowledge in accordance with a quantity you assign it — therefore the “N” within the political name. Term, you’ve gotten 1,000 merchandise that your organization sells and also you wish to view solely the highest 5 merchandise: For that, you’d use a Prime N snakehead.

Bạn Đang Xem: How to create or use a Top N filter in Tableau

SEE: Analysis: Digital transformation initiatives give attention to cooperation (TechRepublic Premium)

Tableau helps Prime N filters, {but} they could be a bit difficult to construct. I’m going to point out you similar to do exactly that through the Tableau Desktop App utilizing the Superstore pattern knowledge.

What you’ll want

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

Depreciation to construct the Prime N snakehead

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

Open the Tableau Desktop app after which friendship to the Superstore pattern knowledge. When you’ve achieved that, open 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 correct cabinets.

Xem Thêm : LG’s new OLED monitor is play sufficient to switch your TV

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

Determine B

Creating a brand new parameter for the Prime N snakehead.

Political name the brand new parameter Prime 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} OK. Subsequent, on the Rows shelf, right-click on Producer and choose {Edit} Snakehead (Determine D).

Determine D

Our snakehead is able to {edit}.

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

Xem Thêm : A complete overview of Home windows 11 22H2, the OS’s first make fun yearly replace

Determine E

Configuring our new snakehead.

Again within the Information pane (far left pane), below Parameters, right-click on Prime N and choose Present Parameter (Determine F).

Determine F

It’s date and time to point out our Prime N parameter.

When you’ve achieved this, you need to see a Prime N slider within the higher proper nook of the view (Determine G).

Determine G

You’ll be able to {change} the sector by transferring the slider to the precise or left to point out extra re-launch.

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

Subscribe to TechRepublic’s Depreciation To Make Tech Work on YouTube for hustle the most recent tech protect for enterprise professionals from Jack Wallen.

Danh mục: Tech

Leave a Reply

Your email address will not be published.