Analytics-DA-201 - Explore and Analyze Data (41% of the exam) - Section 2.4
Apply dimension and measure filters, configure Top/Bottom N, wildcard, include, exclude, and conditional filters, add filters to context, and apply filters across multiple sheets and data sources.
Practice question for this objective
lock_openFree sampleExplore and Analyze Datamedium
A dashboard has two worksheets that come from two different published data sources: a Sales sheet and a Support Tickets sheet. Both data sources contain a Region field with identical region names. An analyst wants a single Region filter that, when changed, narrows both worksheets together. What is the correct way to make one Region selection drive both data sources?
AConfigure the Region filter as a dashboard filter and use Apply to Worksheets with a field-based relationship so the matching Region field in each data source is filtered together.check_circle Correct
BPlace a Region filter on the Sales sheet and choose Apply to Worksheets, All Using This Data Source, expecting it to reach the Support Tickets sheet as well.
CAdd the Region filter to the dashboard, open its menu, and use Apply to Worksheets, Selected Worksheets, then tick both sheets and confirm the data sources are blended.
DCreate separate Region filters on each worksheet and rely on the dashboard to synchronise their selections automatically because the field names match.
Apply a single filter across worksheets drawn from multiple data sources by matching a common field between the sources. A filter only spans multiple data sources when Tableau is told which field is common to each, so configuring the Region filter to map to the matching Region field across both sources lets one selection narrow both worksheets at once.
Why A is correct: Applying a filter across multiple data sources requires Tableau to match a common field; once Region is set as the shared field across the sources, one selection filters both worksheets, which is exactly the cross-source filtering the analyst needs.
Why B is wrong: All Using This Data Source only spreads the filter to sheets on the same source, so the Support Tickets sheet on a different data source is left untouched.
Why C is wrong: Selected Worksheets only works across data sources when those sources are linked by a relationship; simply ticking two sheets from separate sources does not by itself filter the second, and the option assumes a blend that is not described.
Why D is wrong: Two independent filters do not synchronise just because the field names match; the viewer would have to set each one separately, defeating the single-control requirement.
Answers that look right on this material and are not. Each one is a distractor from a different question in the Analytics-DA-201 bank for this domain.
Raise the Top N value from 8 to a larger number such as 30 so that more product lines survive the regional filter step.
errorWhy it is wrong: Increasing the count does not change filter ordering; the ranking is still built across all regions before Perth narrows it.
Add the Region filter to context so it is evaluated before the Top 10 filter, leaving the Top N computed across all regions.
errorWhy it is wrong: Adding Region to context makes Region a precedent filter, which is the opposite of what is needed: the Top 10 would then be recalculated within the one retained region rather than across all of them.
The first field was set to continuous and the second to discrete, and continuous fields always show tick boxes while discrete fields always show range sliders.
errorWhy it is wrong: This is tempting because discrete and continuous do shape behaviour, but it inverts the relationship: continuous fields offer ranges and discrete fields offer member lists, so the description is back to front.