Tableau Desktop Specialist · Free Practice Question Medium
Question 25
A supply chain manager is analyzing inventory levels in Tableau Desktop using a dataset from an Oracle database table named "InventoryRecords". The table includes fields like "ProductID", "Category", "Subcategory", "Warehouse", and "StockLevel". The manager wants to streamline the dashboard by creating a hierarchical structure for navigation and ensure that only warehouses with stock levels above a certain threshold are analyzed, while still allowing flexibility for ad-hoc filtering by category.
After connecting to the data, the manager opens the Data pane to organize and filter the dataset. Which of the following actions can the manager take to achieve these goals in Tableau Desktop?
-
A
Create a calculated field to rank warehouses by "StockLevel," then use it as a top N filter to dynamically limit the dataset to high-stock warehouses.
-
B
Right-click "Category" in the Data pane, select "Default Properties," and set it as a default filter to automatically apply across all new worksheets.
-
C
Group similar "Warehouse" values into broader regions, then apply a data source filter on "StockLevel" to exclude low inventory locations across the entire workbook.
-
D
Select "Category" and "Subcategory" in the Data pane, right-click, and choose "Create Hierarchy" to enable drill-down navigation in visualizations.
-
E
Drag "Warehouse" to the Filters shelf, set a condition for "StockLevel" greater than a specific value, and convert it to a context filter to prioritize it over subsequent filters.
Reveal correct answers
Correct answers: D, E
A.
A calculated field to rank warehouses (e.g., RANK(SUM([StockLevel]))) and a top N filter (https://help.tableau.com/current/pro/desktop/en-us/filter_top.htm) is a creative approach, but it’s unnecessarily complex for a static threshold requirement.
It also shifts focus to ranking rather than a simple condition, straying from the scenario’s intent.
B.
"Default Properties" in the Data pane (https://help.tableau.com/current/pro/desktop/en-us/data_properties.htm) adjusts field settings (e.g., sort order), but it doesn’t set "Category" as a default filter.
Filters aren’t applied this way—tableau uses the Filters shelf or data source filters, making this option misleading.
C.
Grouping "Warehouse" values into regions is feasible, but it’s not mentioned as a requirement—organizing by "Category" and "Subcategory" is the focus.
A data source filter (https://help.tableau.com/current/pro/desktop/en-us/filter_datasource.htm) on "StockLevel" would work globally, but it’s too rigid, limiting ad-hoc flexibility (e.g., exploring low-stock scenarios), which the question implies is needed.
D.
Creating a hierarchy (https://help.tableau.com/current/pro/desktop/en-us/hierarchies.htm) with "Category" and "Subcategory" organizes the data for drill-down navigation, directly meeting the goal of streamlining the dashboard. This is a core Tableau feature for data organization.
E.
Applying a filter on "Warehouse" with a condition based on "StockLevel" (https://help.tableau.com/current/pro/desktop/en-us/filter_conditions.htm) and converting it to a context filter (https://help.tableau.com/current/pro/desktop/en-us/filter_context.htm) ensures it takes precedence over other filters (e.g., ad-hoc category filters).
This meets the requirement for prioritizing stock-level thresholds while allowing flexibility.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
