Join the discussion
Question 147/148
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?

You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
Correct Answer: D
To use the City dimension to create a dynamic filter that shows the cities that have a population greater than one million, you should use a condition filter. A condition filter is a type of filter that shows only the values that meet a specified condition based on a measure or a calculation. You can create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the dialog box. Then you can enter a formula or choose an option that defines your condition.
In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.
The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as "New*" or "*ton". A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation. Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.
The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as "New*" or "*ton". A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation. Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
Add Comments
- Other Question (148q)
- Q1. You have the following dataset. (Exhibit) Yon need to calculate the ranking shown in the R...
- Q2. Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet. Modify...
- Q3. You have the following line chart that shows the average sales by month. (Exhibit) Which m...
- Q4. You have the following dataset. When you use the dataset in a worksheet, you want Sales to...
- Q5. Open the link to Book1 found on the desktop. Use the Superstore data source. Split the Cus...
- Q6. Open the link to Book1 found on the desktop. Open the Movie Durations worksheet. Replace t...
- Q7. You have a data source that contains the following columns. (Exhibit) You want to sort cus...
- Q8. You have the following chart that sorts states by the number of products each state has pu...
- Q9. You are the owner of an alert. You receive an email notification that the alert was suspen...
- Q10. You have the following dataset. (Exhibit) Which formula calculates the percent difference ...
- Q11. You have the following dashboard. (Exhibit) When a user selects a only on the map the data...
- Q12. You company has two divisions located in the United States and Germany Bach division has a...
- Q13. You create a worksheet named Sales by Region and hide the tide of the worksheet. You print...
- Q14. You have a data source that contains data tor every city in the Unites States. The followi...
- Q15. You have the following tiled dashboard that has one sheet. (Exhibit) You want to replace f...
- Q16. You have a Tableau workbook that has a live data source. The data source connects to a Mic...
- Q17. Open the link to Book1 found on the desktop. Use the Superstore data source. Split the Cus...
- Q18. You have a database that includes field named sales, City and Region. You have the followi...
- Q19. Open the link to Book1 found on the desktop. Open Disciplines worksheet. Filter the table ...
- Q20. A Data Analyst has the following view. (Exhibit) The analyst wants to filter the view to s...
- Q21. You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00....
- Q22. Open the link to Book1 found on the desktop. Open Disciplines worksheet. Filter the table ...
- Q23. You plan to publish a workbook to Tableau Server. You want to ensure that users can see ot...
- Q24. You are developing a data source in Tableau Prep. You have two tables named Orders and Emp...
- Q25. You have the following dataset: (Exhibit) You want to create a parameter to dynamically fi...
- Q26. You subscribe to a view that delivers a daily email to your inbox. You want to make the su...
- Q27. You have the following data source in tableau Server. (Exhibit) You need to ensure that th...
- Q28. You have the following visualization. (Exhibit) The Last() calculation is set to compute u...
- Q29. You have the following dataset that contain null values in the Profits field. (Exhibit) Yo...
- Q30. You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet. What...
- Q31. You have a database that includes field named sales, City and Region. You have the followi...
- Q32. You are creating a new dashboard. You need to add a button to the dashboard that allows us...
- Q33. You have the following dataset in Microsoft Excel. (Exhibit) You are using interpreter to ...
- Q34. You have the following dataset. (Exhibit) You need to create the following worksheet. (Exh...
- Q35. When a Data Analyst needs to format workbook settings, which options are available in the ...
- Q36. You company has two divisions located in the United States and Germany Bach division has a...
- Q37. Open the link to Book1 found on the desktop. Open the Line worksheet. Modify the chart to ...
- Q38. You have the following worksheet. (Exhibit) You want to create a table calculation that sh...
- Q39. You have a dataset that has four fields named Category. Profit Sates and Customer Name. Yo...
- Q40. A Data Analyst has the following sets in a Tableau workbook: * Top N Customers * Customers...
- Q41. You have the following visualization. (Exhibit) The Last() calculation is set to compute u...
- Q42. You have a line chart on a worksheet. You want to add a comment to March 2020 as shown in ...
- Q43. You plan to create a visualization that has a dual axis chart. The dual axis chart will co...
- Q44. You have the following dashboard that contains two visualizations. (Exhibit) You want to s...
- Q45. You have the following bar chart. (Exhibit) You want the chart to appear as shown in the M...
- Q46. A Data Analyst has a dataset that contains the fallowing rows of sales data. (Exhibit) The...
- Q47. Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Supe...
- Q48. You have a data source that contains the following columns. (Exhibit) You want to filter r...
- Q49. Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Supe...
- Q50. You have a database that includes field named sales, City and Region. You have the followi...
- Q51. You have a dashboard that is configured for desktop browsers. You want to customize a layo...
- Q52. You have a workbook that connects to a database. The database requires authentication. You...
- Q53. A Data Analyst has the following dataset: (Exhibit) The analyst wants to create a new calc...
- Q54. You have the following dataset. (Exhibit) Which Level of Detail (LOD) expression should yo...
- Q55. You create a parameter named Choose Region fiat contains values from a field named Region....
- Q56. When should a Data Analyst use a Treemap in Tableau?...
- Q57. You are developing a data source in Tableau Prep. You have two tables named Orders and Emp...
- Q58. In a dataset, you have a string field named Name that contains unnecessary semicolons. Whi...
- Q59. You have the following dashboard. (Exhibit) When a user selects a only on the map the data...
- Q60. You have a dataset that contains daily sales by business segment from 2017 to the present ...
- Q61. You want to create the following table in a view. (Exhibit) Which function should you use ...
- Q62. A Data Analyst is using containers on a dashboard. How should the analyst make sure multip...
- Q63. You have a workbook that connects to a database. The database requires authentication. You...
- Q64. You have a data source that contains data tor every city in the Unites States. The followi...
- Q65. You have the following table. (Exhibit) You need each record to alternate between grey and...
- Q66. Open the link to Book1 found on the desktop. Open the Line worksheet. Modify the chart to ...
- Q67. A Data Analyst has a data source that contains the following columns: (Exhibit) he analyst...
- Q68. You have the following dashboard. (Exhibit) When a user selects a only on the map the data...
- Q69. A Data Analyst has the following bar chart. (Exhibit) The analyst wants the chart to appea...
- Q70. Open the link to Book1 found on the desktop. Open the sales dashboard. Add the Sales by St...
- Q71. A Data Analyst has the following chart that shows the sum of sales made in different citie...
- Q72. You have a data source that contains data tor every city in the Unites States. The followi...
- Q73. You are the owner of an alert. You receive an email notification that the alert was suspen...
- Q74. You have the Mowing dashboard. (Exhibit) Which two elements are floating? Choose two....
- Q75. In a dataset, you have a string field named Name that contains unnecessary semicolons. Whi...
- Q76. You have the Mowing dashboard. (Exhibit) Which two elements are floating? Choose two....
- Q77. A Data Analyst has a workbook that uses an extracted data source. The analyst publishes th...
- Q78. You have the following calculated fields in a worksheet. [Calc1] = DATEADD ('year', -1, TO...
- Q79. You have the following box plot that shows the distribution of average profits made in eve...
- Q80. A colleague provides you with access to a folder that contains the following files: * Sate...
- Q81. You have the following dashboard that contains two visualizations. (Exhibit) You want to s...
- Q82. How should a Data Analyst sort data by Sales across multiple dimensions in Tableau?...
- Q83. You use a quick table calculation lo calculate the moving average of a measure named Sales...
- Q84. You have the Mowing dashboard. (Exhibit) Which two elements are floating? Choose two....
- Q85. You want to create the following table in a view. (Exhibit) Which function should you use ...
- Q86. You have the following dataset You need to create the following visualization. (Exhibit) W...
- Q87. You have a table that contains four columns named Order Date, Country, Sales, and Profit. ...
- Q88. You have a dashboard that contains a parameter named Start Date. You need to create an ext...
- Q89. You have the following two datasets: * A Microsoft Excel worksheet that has two columns na...
- Q90. From Tableau Desktop you sign in lo a Tableau Server site. What appears in the list of ava...
- Q91. You have the following tiled dashboard that has one sheet. (Exhibit) You want to replace f...
- Q92. A Data Analyst needs to update an existing dashboard. The current dashboard shows financia...
- Q93. You have a dataset that contains daily sales by business segment from 2017 to the present ...
- Q94. In a dataset, you have a string field named Name that contains unnecessary semicolons. Whi...
- Q95. You have the following: Overall Rank and Rank are calculated fields that use the RANK func...
- Q96. You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00....
- Q97. A colleague provides a Data Analyst with access to a folder that has the following files: ...
- Q98. Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet. Modify...
- Q99. A Data Analyst has the following chart that shows the cumulative volume of sales from vari...
- Q100. You want to show the cumulative total of each year for every state. Which quick table calc...
- Q101. In a worksheet, you have a calculated column named YTD Sales that uses the following formu...
- Q102. You have a dashboard than contains two sheets named Sheet 1 and Sheet 2. You want to add a...
- Q103. A Data Analyst has a dataset that contains people and the awards they have won. (Exhibit) ...
- Q104. Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data so...
- Q105. You have a data source that has two tables named Table1 and Table2. Table1 is the primary ...
- Q106. A colleague provides you with access to a folder that contains the following files: * Sate...
- Q107. You have the following bar chart. (Exhibit) You want the chart to appear as shown in the M...
- Q108. You have the following dataset: You want to create a parameter to dynamically filter the d...
- Q109. You conned to a Microsoft SQL Server database You need to create a custom SQL query that r...
- Q110. You have the following Map. (Exhibit) You need the map to appear as shown in the following...
- Q111. You have the following map. (Exhibit) You need the map to appear as shown in the following...
- Q112. You create a parameter named Choose Region fiat contains values from a field named Region....
- Q113. A Data Analyst needs to analyze the financial performance of the sales team. In order to m...
- Q114. Open the link to Book1 found on the desktop. Open the sales dashboard. Add the Sales by St...
- Q115. You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset nam...
- Q116. You are subscribed to several views. You need to unsubscribe from the views. What should y...
- Q117. Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet. Modify...
- Q118. You have the following dataset (Exhibit) You need to create the following visualization. (...
- Q119. You have the following view. (Exhibit) You want to filter the view lo show only records th...
- Q120. (Exhibit) How are the colors configured for the map?...
- Q121. You have a dataset that contains daily sales by business segment from 2017 to the present ...
- Q122. You have the following view. (Exhibit) You want to filter the view lo show only records th...
- Q123. You have the following: (Exhibit) Overall Rank and Rank are calculated fields that use the...
- Q124. Open the link to Book1 found on the desktop. Open Disciplines worksheet. Filter the table ...
- Q125. You have the Mowing two tables that contains data about the books in a library. Both table...
- Q126. You use a quick table calculation lo calculate the moving average of a measure named Sales...
- Q127. You have a data source that contains 20 tables. You want the tables to be organized within...
- Q128. You have the following box plot that shows the distribution of average profits made in eve...
- Q129. You have a dashboard that contains a parameter named Start Date. You need to create an ext...
- Q130. Open the link to Book1 found on the desktop. Open Disciplines worksheet. Filter the table ...
- Q131. You plan to create a visualization that has a dual axis chart. The dual axis chart will co...
- Q132. You have the following dataset that contain null values in the Profits field. (Exhibit) Yo...
- Q133. You have the following map. (Exhibit) You need the map to appear as shown in the following...
- Q134. You have a large data source that contains more than 10 million rows. Users can filter the...
- Q135. You have the following dashboard. (Exhibit) Currently the map is used as a filter that aff...
- Q136. You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3. ...
- Q137. You have a sales dataset that contains the following fields. (Exhibit) You need to analyze...
- Q138. You have the following dataset. (Exhibit) You want to create a new calculated dimension fi...
- Q139. You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset nam...
- Q140. You have the following visualization. (Exhibit)...
- Q141. You are subscribed to several views. You need to unsubscribe from the views. What should y...
- Q142. You have a data set that contains three columns named Sales, Profit, and Quantity. You nee...
- Q143. in which three formats can you export a worksheet from the Worksheet menu? Choose three...
- Q144. You have a line chart on a worksheet. You want to add a comment to March 2020 as shown in ...
- Q145. You have the following tiled dashboard that has one sheet. (Exhibit) You want to replace t...
- Q146. Open the link to Book1 found on the desktop. Open the Line worksheet. Modify the chart to ...
- Q147. You have a data source that contains data tor every city in the Unites States. The followi...
- Q148. You have a data source that has two tables named Table1 and Table2. Table1 is the primary ...
