What’s great about it, is that the list is dynamic, meaning that if the data changes, our top list will be updated accordingly. Here we have the final chart displaying the top 10 best-sold products. Select the Top section and edit “By Field” requirementsįor this tutorial, I’ve selected to be shown the top 10 sub-categories by sum of sales. Go to the Top section, select “By field”, choose “Top” and write the number of items you want to be displayed in the chart, which can be any number you want.
Right click on the newly created filter and click “Edit Filter…” Show only the Top 10 resultsįirst, create a filter by dragging the main dimension you want to use as a filter to the “Filter” area. We can easily see that we have 17 dimensions, but we only want the top 10. Now we have the rank numbers (index rows) displayed in our charts. Right click on the calculated field you created, Index, click on “Convert to Discrete” If you want to get a better perspective on how many rows are displayed.Ĭreate a calculated field with the following formula: INDEX() This step is optional, but helpful when creating lists or table views. Optional: create an index to see the # of rows To achieve that, click on the “Sort” icon (arrow down) found in the toolbar. That’s why we need to sort the view descending by total sales within product categories. We want to see the top performing products first, from the best performing ones to the worst ones. Sort the view in a descending order by sales In this example, I’ve plotted the required data in a horizontal bar chart view.īy default, the chart below shows all the products and total sales in an alphabetical order. Final Result How to show top 10 records in Tableau 1.
0 kommentar(er)
