Tableau Quiz: Sets
10 questions · exam conditions
0:00
SetsQuestion 1 of 10

A workbook contains [Top Revenue Customers], a dynamic set of the top 2020 customers by SUM(Sales), and [Profitable Customers], a dynamic set whose members have SUM(Profit) greater than 00. The analyst needs one segment containing only customers who satisfy both definitions.

Which set construction should the analyst use?

Combine the sets using members in either set, producing their union.
Combine the sets using shared members, producing their intersection.
Combine the sets using revenue members except profitable members, producing their difference.
Group both sets and retain every customer represented by either group.
← Back to quizzes

Tableau Quiz

Tableau Quiz: Sets

Practice Sets in Tableau with focused quiz questions that help you check what you know, review explanations, and build confidence with test-style prompts.

What this quiz covers

This quiz focuses on Sets, giving you a quick way to practice the rules, question types, and explanations that matter most for Tableau.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

All questions

Question 1

A workbook contains [Top Revenue Customers], a dynamic set of the top 2020 customers by SUM(Sales), and [Profitable Customers], a dynamic set whose members have SUM(Profit) greater than 00. The analyst needs one segment containing only customers who satisfy both definitions.

Which set construction should the analyst use?

  1. Combine the sets using members in either set, producing their union.
  2. Combine the sets using shared members, producing their intersection. (correct answer)
  3. Combine the sets using revenue members except profitable members, producing their difference.
  4. Group both sets and retain every customer represented by either group.
Explanation: When working with combined sets in Tableau, the key question to ask is: what relationship between the two sets defines my target segment? Here, the analyst wants customers who are both top revenue earners and profitable — meaning a customer must appear in both sets simultaneously to qualify. This is the textbook definition of a set intersection. Combining [Top Revenue Customers] and [Profitable Customers] using shared members returns only the customers present in both sets — exactly the segment described. That makes B the correct choice. A is wrong because a union returns every customer who satisfies either condition — top 2020 by revenue or profitable. This inflates the segment by including high-revenue customers who lose money and profitable customers outside the top 2020, which is the opposite of what the analyst needs. C describes a set difference, which would return top revenue customers who are not profitable — essentially filtering out the very people the analyst wants to keep. This inverts the logic entirely. D is a distractor that sounds similar to a union but frames it in terms of "groups" rather than sets. Tableau's native Combine Sets feature operates on sets specifically, and the word "every customer represented by either group" still describes a union — making this doubly wrong. A helpful memory trick: think of set operations like a Venn diagram. Union = everything in both circles. Intersection = only the overlapping middle. Whenever a question uses language like "satisfies both" or "must meet all conditions," that's your signal to reach for the intersection.

Question 2

A customer set is defined by the condition SUM(Sales) greater than 100,000100{,}000. With no filters applied, Customer A has annual sales of 120,000120{,}000 but January sales of only 4,0004{,}000. The analyst adds Month to the view and uses the customer set on Color.

How will Customer A's January mark normally be classified?

  1. Out, because adding Month converts every condition-based set into a fixed monthly set.
  2. Out, because the January mark does not independently exceed the set's sales threshold.
  3. In, because membership is evaluated from Customer A's qualifying total, not separately for each month mark. (correct answer)
  4. In, because every customer is automatically included until the set is placed on Filters.
Explanation: When working with Tableau sets, the most important concept to keep in mind is when membership is evaluated. A condition-based set asks a single question — does this member meet the condition? — and that question is answered using the member's total aggregated data, not the data visible in any particular view. Customer A has annual sales of $120,000\$120{,}000, which exceeds the $100,000\$100{,}000 threshold. That evaluation happens once, at the member level. When you drag Month to the view, Tableau disaggregates the display, but it does not re-evaluate set membership for each row. Customer A is already marked In, and that classification travels with every mark belonging to Customer A — including January's $4,000\$4{,}000 mark. That's why C is correct. Choice A is wrong because adding a dimension to the view never converts a condition-based set into a dimension-specific one. The set definition doesn't change just because your view does. Choice B reflects a very common misconception: it assumes Tableau re-tests the threshold against the filtered, disaggregated value ($4,000\$4{,}000). That would only be true if you had defined a row-level calculated field, not a set. Choice D is wrong because set membership has nothing to do with whether the set is on the Filters shelf — a customer's In/Out status is determined entirely by whether they satisfy the set's condition. As a study tip, always ask yourself: at what grain was the set defined? If it was defined on Customer, membership is fixed at the Customer grain regardless of what else you add to the view.

Question 3

An analyst has two dynamic customer sets: [High Sales Set] and [High Profit Set]. The analyst needs four mutually exclusive segments: Stars for members of both sets, Volume for members of only the sales set, Efficient for members of only the profit set, and Other for members of neither set.

Which calculated-field logic correctly creates the four segments?

  1. IF [High Sales Set] AND [High Profit Set] THEN 'Stars' ELSEIF [High Sales Set] THEN 'Volume' ELSEIF [High Profit Set] THEN 'Efficient' ELSE 'Other' END (correct answer)
  2. IF [High Sales Set] OR [High Profit Set] THEN 'Stars' ELSEIF [High Sales Set] THEN 'Volume' ELSEIF [High Profit Set] THEN 'Efficient' ELSE 'Other' END
  3. IF [High Sales Set] THEN 'Volume' ELSEIF [High Profit Set] THEN 'Efficient' ELSEIF [High Sales Set] AND [High Profit Set] THEN 'Stars' ELSE 'Other' END
  4. IF NOT [High Sales Set] AND NOT [High Profit Set] THEN 'Stars' ELSEIF [High Sales Set] THEN 'Efficient' ELSEIF [High Profit Set] THEN 'Volume' ELSE 'Other' END
Explanation: When building mutually exclusive segments with nested IF logic in Tableau, order matters enormously. The most specific condition must come first — if a broader condition appears earlier, it "captures" records that should have matched a later, more specific branch. Answer A is correct because it tests the intersection first: IF [High Sales Set] AND [High Profit Set] THEN 'Stars'. Only customers in both sets reach this branch. Customers who fall through are then tested individually — ELSEIF [High Sales Set] catches sales-only members ("Volume"), ELSEIF [High Profit Set] catches profit-only members ("Efficient"), and everyone else becomes "Other." Each branch is truly mutually exclusive because Tableau evaluates conditions top-to-bottom and exits at the first true match. B fails immediately because it uses OR in the first condition, which catches any customer in either set and labels them "Stars." The subsequent ELSEIF branches become unreachable for those customers, so "Volume" and "Efficient" are never assigned correctly. C places the AND condition after the individual set checks. By the time Tableau reaches ELSEIF [High Sales Set] AND [High Profit Set], customers in both sets have already been captured by the first IF [High Sales Set] branch and labeled "Volume" — the "Stars" segment is never populated. D inverts the logic entirely, assigning "Stars" to customers in neither set (which should be "Other") and swapping the labels for "Efficient" and "Volume." Strategy tip: In any multi-branch IF/ELSEIF calculation, always place the most restrictive (most conditions combined with AND) test first. Broad conditions early will silently swallow records that belong in specific segments.

Question 4

A dashboard uses a set action to place selected customers in [Selected Customers]. The business wants selected and unselected customers displayed simultaneously as two color segments. A percent-of-total calculation must continue to use sales from both segments.

How should [Selected Customers] be used in the worksheet?

  1. Place the set on Filters, select In, and compute the percentage using only visible marks.
  2. Place the set on Color, retaining both In and Out members in the displayed data. (correct answer)
  3. Place the set in context, then display customer names as labels for both segments.
  4. Place the set on Filters, select Out, and duplicate the worksheet for selected customers.
Explanation: When working with Tableau sets, the key question to ask is: what do I want to happen to the data that isn't selected? Sets have two states — In (selected members) and Out (everyone else) — and where you place a set on the view determines whether both states remain visible or one gets filtered away. Here, the business needs both segments visible simultaneously with distinct colors, and the percent-of-total must include sales from all customers, not just the selected ones. Placing the set on Color achieves exactly this: Tableau splits marks into In and Out groups, renders each in a different color, and keeps all underlying data intact for table calculations. Your percent-of-total calculation can still reference the full dataset because no rows have been removed. A is wrong because placing the set on Filters and selecting "In" removes Out members from the view entirely. You'd lose the unselected segment visually, and your percent-of-total would calculate only against the filtered subset — breaking both requirements. C is a distractor that sounds plausible but misuses the concept of context filters. Adding a set to context changes the order of query operations; it doesn't create a dual-segment color display, and it still restricts which marks appear based on set membership. D compounds the problem in A by duplicating worksheets — a workaround that defeats the purpose of a set action and creates synchronization headaches. It also still filters data in each sheet, corrupting the percent-of-total. Study tip: On set questions, remember the rule — Filter removes, Color reveals. If the requirement is "show both," your answer almost always involves Color, not Filters.

Question 5

A worksheet uses a dynamic customer set defined as the top 1010 customers by SUM(Sales). The dashboard also has a single-value [Region] filter. Users expect the set to identify the top customers within the selected region, but it continues to reflect top customers across all regions.

Which change most directly produces the expected dynamic segmentation?

  1. Add [Region] to context so the top set is evaluated from the region-filtered data. (correct answer)
  2. Convert the customer set to a fixed set after users select the required region.
  3. Place the customer set on Filters before placing [Region] on the Filters shelf.
  4. Replace the [Region] dimension filter with a measure filter based on SUM(Sales).
Explanation: Whenever you see a question about dynamic sets and filters in Tableau, the key concept to understand is filter evaluation order. Tableau processes filters in a specific sequence: context filters → dimension filters → measure filters. A dynamic set (like "Top 10 by SUM(Sales)") is evaluated against whatever data exists after context filters have been applied, but before standard dimension filters. This is precisely why A is correct. When [Region] sits on the Filters shelf as a standard dimension filter, the Top 10 customer set is computed first — across all regions — and then the region filter narrows the view afterward. The set never "sees" the region restriction. By adding [Region] to context, you promote it to run before the set is evaluated, so the set calculation draws only from region-filtered data. The result is exactly what users expect: the top 10 customers within the selected region. Option B describes converting to a fixed set, which permanently locks in specific customer names rather than dynamically recalculating — this defeats the purpose of a dynamic set entirely and requires manual intervention each time. Option C has the logic backwards: placing the customer set on Filters before [Region] doesn't change Tableau's evaluation order, because filter shelf position doesn't override the built-in processing hierarchy. Option D replaces the dimension filter with a measure filter, but measure filters evaluate even later in Tableau's order than dimension filters — this would make the segmentation problem worse, not better. A helpful rule of thumb: if a filter needs to shape the data that another calculation sees, promote it to context. Think of context as "setting the stage" before all other computations run.

Question 6

A dynamic product set uses all products as candidates, applies the condition SUM(Sales) at least 50,00050{,}000, and then keeps the top 55 qualifying products by SUM(Profit). Product X ranks sixth in profit among all products. However, two higher-profit products fail the sales condition, making Product X fourth in profit among products that satisfy the condition.

Assuming no other filters affect the calculation, how is Product X classified?

  1. Out, because a set cannot apply a condition and a top limit simultaneously.
  2. Out, because X ranks sixth before the sales condition removes ineligible products.
  3. In, because the condition first limits eligible products and X is then within the top 55. (correct answer)
  4. In, because meeting the sales condition makes the top-profit requirement optional.
Explanation: When working with dynamic sets in Tableau that combine a condition and a top N limit, the order of operations matters enormously. The condition acts as a filter first, narrowing the candidate pool, and then the top N ranking is applied only to the survivors of that condition — not to the full original list. Here's how that plays out for Product X. The set starts with all products, then discards any product where SUM(Sales)<50,000\text{SUM(Sales)} < 50{,}000. Two products that outrank X in profit are eliminated at this stage. Among the remaining eligible products, X sits fourth in profit — comfortably inside the top 55 cutoff. That makes C the correct answer: the condition gates who can compete for the top spots, and X clears both hurdles. Answer A is wrong because Tableau absolutely supports combining a condition and a top N filter within a single dynamic set — that's a core feature of how sets are configured. Answer B reflects a common misconception: ranking sixth before the condition is applied is irrelevant once ineligible products are removed. The final ranking is determined after filtering, not before. Answer D invents a rule that doesn't exist; satisfying the sales condition doesn't waive the profit ranking requirement — both criteria must be met, in sequence. A useful mental model: think of the condition as the qualifying round and the top N as the final round. Only qualifiers compete in the final. On Tableau exam questions involving dynamic sets, always ask yourself which step happens first and what the eligible pool looks like before the ranking is applied.

Question 7

A set action places selected states into [Highlighted States]. When a user clicks empty space and clears the selection, the dashboard should return to its baseline state in which every state is a member of the set.

Which clearing-selection option should be used for the set action?

  1. Keep set values, preserving only the states from the most recent selection.
  2. Add all values to the set, restoring every state as an In member. (correct answer)
  3. Remove all values from the set, restoring every state as an Out member.
  4. Assign selected values to the set, retaining the marks selected before clearing.
Explanation: When working with Set Actions in Tableau, the key concept to master is how the clearing behavior controls what happens to a set's membership when a user deselects everything. Each set action has three configurable options for what happens on clearing: keep current values, add all values, or remove all values. The question is asking which behavior restores the set to a "show everything" baseline. The scenario requires that clearing a selection returns every state to membership in the set — meaning all states should be In. That maps directly to B: Add all values to the set. When the selection is cleared, Tableau adds every value back into the set, making all states In members and restoring the full, unfiltered baseline view. This is the standard pattern for "reset to show all" dashboard behavior. Choice A is wrong because "Keep set values" preserves only the states from the last selection, leaving the set in a filtered state rather than resetting it — users would be stuck with whatever was last clicked. Choice C does the opposite of what you need: removing all values makes every state an Out member, which would blank out the dashboard rather than restore it. Choice D is a fabricated option — Tableau's set action clearing behavior does not include an "assign selected values" mode, making this a distractor testing whether you know the actual three options. A useful tip: memorize the three clearing options as Keep / Add All / Remove All, and match them to outcomes — Add All = full inclusion (show everything), Remove All = full exclusion (show nothing). Exam questions almost always hinge on distinguishing these two.

Question 8

An analyst selects the customer marks currently showing a profit ratio above 20%20\% and chooses Create Set. After the data refreshes, some selected customers fall below the threshold and new customers rise above it, but the set membership does not change.

What should the analyst do to make the segment update according to the threshold?

  1. Sort customers by profit ratio and preserve the original selected-member set membership.
  2. Retain the selected-member set and add it to context before each data refresh.
  3. Convert the selected customers into a group and refresh the group aliases automatically.
  4. Edit the set to use a condition based on the required aggregated profit-ratio calculation. (correct answer)
Explanation: When working with Tableau sets, the critical distinction to understand is between fixed membership and condition-based membership. A set created by manually selecting marks captures a static snapshot — those exact members are locked in regardless of what happens to the underlying data. This question tests whether you understand how to make a set behave dynamically. The correct approach is D: editing the set to use a condition based on an aggregated profit-ratio calculation. A condition-based set re-evaluates its membership criteria every time the data refreshes, so customers automatically enter or exit the set depending on whether they currently meet the threshold. This is exactly the dynamic behavior the analyst needs. A is a distractor that misunderstands the problem — sorting by profit ratio does nothing to change set membership logic. Sorting is a display operation, not a segmentation rule. B introduces context filters, which control query order and performance but have no bearing on whether set membership is fixed or dynamic. Adding a fixed set to context before a refresh still doesn't make that set recalculate its members. C confuses sets with groups. Groups are purely static label-based clusters used to combine dimension members manually — they have no conditional logic and cannot automatically update based on a measure like profit ratio. Aliases are display names, not recalculation triggers. A useful rule of thumb: if you ever need a segment that reacts to data changes, reach for a condition-based or formula-based set, not a selected-member set. The phrase "does not change after refresh" is a strong signal that you need to swap static selection for dynamic condition logic.

Question 9

Dashboard users must be able to choose any number of product names from a displayed list. Chosen products should be classified as In and all remaining products as Out across worksheets using the same data source. The unchosen products must remain visible.

Which design best satisfies the requirement without dashboard navigation?

  1. Create a product-name set, show its set control, and use the set for In/Out encoding. (correct answer)
  2. Create a product-name filter, show its filter card, and retain only selected product values.
  3. Create a product parameter, show its control, and compare each product with the parameter.
  4. Create a product group, show its header, and let users edit aliases for membership.
Explanation: When a question asks about classifying items as "In" or "Out" while keeping all items visible, you're being tested on Tableau's set functionality — specifically the difference between sets, filters, parameters, and groups. Sets are purpose-built for exactly this scenario. A set divides dimension members into two buckets — In and Out — and a set control lets dashboard users dynamically move members between those buckets with checkboxes. Critically, all members remain visible in the view; they're simply encoded differently based on membership. Answer A leverages this perfectly: create the set, expose the set control, and use the set field for color, shape, or another encoding to distinguish In from Out across worksheets sharing the data source. Answer B is tempting but fundamentally wrong — a filter removes data from the view entirely. The requirement explicitly states that unchosen products "must remain visible," which filters cannot satisfy. Answer C fails because a parameter holds only a single value (or a fixed list with single selection), so it cannot support choosing "any number" of products simultaneously without complex workarounds. Answer D is impractical and misuses groups — groups are for static, predefined buckets edited by an author in the data pane, not something dashboard viewers can interact with dynamically at runtime. A useful rule of thumb: whenever you see the phrases "any number of members," "In/Out classification," and "remain visible," that's a three-part signal pointing directly to sets with a set control. Filters hide; parameters hold one value; groups are static — only sets give you dynamic multi-member classification with full visibility.

Question 10

A dashboard set action targets [Focus Accounts]. On each new selection, the business wants the set to contain exactly the account values represented by the currently selected marks. Values from a previous selection must not remain unless they are selected again.

Which running-action behavior should be configured?

  1. Keep set values so selection changes leave the existing membership unchanged.
  2. Add values to the set so each selection accumulates with previous membership.
  3. Remove values from the set so selected accounts are excluded from membership.
  4. Assign values to the set so each selection replaces the previous membership. (correct answer)
Explanation: When working with Tableau set actions, the key concept to understand is how the running-action behavior controls what happens to set membership each time a user makes a new selection. Think of it as choosing a replacement strategy versus an accumulation strategy. The business requirement here is precise: the set must contain exactly the currently selected marks, with no carryover from previous selections. This points directly to the Assign behavior (D). Assign replaces the entire set membership with whatever is currently selected — a clean swap every time. It's the only behavior that guarantees the set mirrors the active selection, nothing more and nothing less. A is wrong because Keep freezes the set membership; it ignores the new selection entirely and preserves whatever was there before. This is the opposite of what the business wants — they explicitly need the set to update with each selection. B is wrong because Add accumulates values over time. Each new selection appends to the existing membership, so old selections linger unless manually cleared. The business requirement states that previous values must not remain, ruling this out completely. C is wrong because Remove does the opposite of adding — it excludes selected marks from the set. So clicking on an account would kick it out of [Focus Accounts], which contradicts the intent of building a focused selection from the clicked marks. As a study tip, remember this shorthand: Assign = replace, Add = accumulate, Keep = freeze, Remove = exclude. On the Tableau exam, whenever a question mentions "exactly" or "replaces previous," that's your signal to choose Assign (D).