Parameter for top N control in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Using Parameter to Filter Top N Customers by Sales

You have a parameter TopN set by the user to select how many top customers to display based on sales. Which Tableau calculation correctly filters the top N customers?

Tableau

RANK(SUM([Sales])) <= [TopN]

A INDEX() <= [TopN]

B SUM([Sales]) >= [TopN]

C RANK(SUM([Sales])) <= [TopN]

D RANK([TopN]) <= SUM([Sales])

💡 Hint

Think about how ranking works and how to compare it with the parameter value.

The RANK(SUM([Sales])) <= [TopN] expression ranks customers by sales and keeps only those with rank less than or equal to the parameter value.

❓ visualization

intermediate

Best Visualization for Top N Parameter Control

You want to let users select the number of top products to display using a parameter. Which visualization type best supports this interactive top N control?

A Bar chart with a parameter control to filter top N products

B Line chart showing sales over time without product filtering

C Scatter plot with fixed axes and no parameter

D Pie chart showing all products without filtering

💡 Hint

Consider which chart type clearly shows ranking and can be filtered by top N.

A bar chart with a parameter control allows users to dynamically filter and see the top N products clearly ranked by sales.

🧠 Conceptual

advanced

Why Use a Parameter for Top N Instead of a Filter?

What is the main advantage of using a parameter to control the top N items displayed instead of a fixed filter in Tableau?

A Parameters allow users to dynamically change the number of items shown without editing the filter each time

B Filters are faster to compute and always better than parameters

C Parameters automatically update with data changes without user input

D Filters can only be applied to dimensions, not measures

💡 Hint

Think about user interaction and flexibility.

Parameters let users choose the number of top items dynamically, making dashboards interactive without needing to edit filters manually.

❓ data_modeling

advanced

Handling Ties in Top N Parameter Filtering

You use a parameter to show the top N customers by sales. Some customers have the same sales amount causing ties at the cutoff. Which approach ensures all tied customers at the cutoff rank are included?

A Use a fixed filter on sales amount instead of ranking

B Use RANK_DENSE(SUM([Sales])) <= [TopN] to include all tied ranks

C Use INDEX() <= [TopN] which ignores ties

D Use RANK(SUM([Sales])) < [TopN] to exclude ties at cutoff

💡 Hint

Consider how different ranking functions treat ties.

RANK_DENSE assigns the same rank to tied values and does not skip ranks, so using it with <= [TopN] includes all tied customers at the cutoff.

🔧 Formula Fix

expert

Debugging a Top N Parameter Calculation Not Filtering Correctly

You created a parameter TopN and a calculated field RANK(SUM([Sales])) <= [TopN] to filter top customers. But the filter shows all customers instead of top N. What is the most likely cause?

A The data source does not support parameters

B The parameter <code>TopN</code> is not set to a valid integer value

C The calculation uses RANK instead of INDEX, causing wrong results

D The filter is applied before the aggregation, so ranking is not computed correctly

💡 Hint

Think about when filters and aggregations happen in Tableau.

Filters applied before aggregation do not have access to aggregated ranks, so the filter does not limit the data as expected. The filter should be applied as a table calculation or after aggregation.