How to create or use a Top N filter in Tableau

Jack Wallen exhibits you Depreciation to construct a High N snakehead in Tableau, therefore you may simply snakehead your merchandise (or any knowledge level) by the “high N” positions.

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

A High N snakehead returns knowledge in line with a quantity you assign it — therefore the “N” within the political name. Term, you will have 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 snakehead.

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

SEE: Analysis: Digital transformation initiatives concentrate on cooperation (TechRepublic Premium)

Tableau helps High N filters, {but} they could be a bit difficult to construct. I’m going to indicate you Depreciation to just do that by way of 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.

Similar to construct the High N snakehead

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

Open the Tableau Desktop app after which love 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 right cabinets.

Xem Thêm : The owner of a 10 billion USD crypto fund first appeared after the collapse

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 High N snakehead.

Political name 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} 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 High tab. Choose By Discipline after which, within the second drop-down, choose “High N.” Ensure Gross sales and Sum are chosen within the different drop-downs and click on OK.

Xem Thêm : The player leaves Axie Infinity

Determine E

Configuring our new snakehead.

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

Determine F

It’s date and time to indicate our High N parameter.

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

Determine G

You’ll be able to {change} the sphere by shifting the slider to the precise or left to indicate extra re-launch.

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

Subscribe to TechRepublic’s Similar To Make Tech Work on YouTube for revelation the newest tech protect for enterprise execs from Jack Wallen.

Danh mục: Tech

Leave a Reply

Your email address will not be published.