Sets for dynamic grouping in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Dynamic Sets in Tableau

Which statement best describes a dynamic set in Tableau?

A A set created manually that never changes unless edited by the user.

B A set that is created using calculated fields but does not respond to filters.

C A set that only includes data from a fixed date range.

D A set that updates automatically based on data changes or user interaction.

💡 Hint

Think about how sets can respond to filters or data updates.

Dynamic sets in Tableau automatically update their members based on data changes or user selections, unlike fixed sets which remain static.

❓ dax_lod_result

intermediate

Result of a Dynamic Set Expression

Given a Tableau dynamic set defined to include customers with sales over $10,000, what will happen if a filter reduces sales data to only $8,000 per customer?

A The set will update to exclude all customers because none meet the $10,000 threshold in the filtered data.

B The set will keep the original customers regardless of the filter.

C The set will show an error because the threshold is not met.

D The set will include all customers since the filter lowers sales.

💡 Hint

Remember that dynamic sets respond to filters and data changes.

Dynamic sets recalculate based on the current data context, so if the filter reduces sales below the threshold, the set updates accordingly.

❓ visualization

advanced

Best Visualization for Dynamic Grouping by Sets

You want to show sales performance grouped dynamically by a set of top 10 products that changes based on user selection. Which visualization type is best suited for this?

A A pie chart showing sales distribution for all products regardless of the set.

B A bar chart with the dynamic set applied as a filter to show only top 10 products.

C A scatter plot showing all products without filtering by the set.

D A line chart showing sales over time without grouping by the set.

💡 Hint

Consider which chart clearly shows grouped categories and updates dynamically.

A bar chart filtered by a dynamic set clearly shows the top 10 products and updates as the set changes, making it the best choice.

❓ data_modeling

advanced

Creating a Dynamic Set for Customer Segmentation

Which approach correctly creates a dynamic set in Tableau to segment customers who made purchases in the last 30 days?

A Create a set based on a calculated field that checks if the purchase date is within the last 30 days, so the set updates as time passes.

B Manually select customers in the data pane and save as a fixed set.

C Create a group of customers and apply a static filter for the last 30 days.

D Use a parameter to select customers but do not link it to purchase dates.

💡 Hint

Think about how to make the set update automatically with time.

Using a calculated field with a date condition allows the set to dynamically include customers based on recent purchases.

🔧 Formula Fix

expert

Debugging a Dynamic Set Not Updating

A dynamic set in Tableau is supposed to update based on a sales threshold but remains static after applying filters. What is the most likely cause?

A The workbook is in read-only mode preventing updates.

B The data source connection is broken, causing the set to freeze.

C The set was created as a fixed set, not dynamic, so it does not respond to filters.

D The filters are applied after the set calculation, so the set ignores them.

💡 Hint

Consider how sets respond to filters and how they are created.

Fixed sets do not update with filters, so if the set was created as fixed, it will remain static despite filter changes.