You have a table that contains the following data.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
A Data Analyst needs to update an existing dashboard. The current dashboard shows financial results data, and users have asked for a comparison of budgets to be added to the dashboard. A new data source has been created that includes both the actual costs and budgets and was published to the corporate Tableau site.
How should the analyst update the existing dashboard?
A Data Analyst has a data source that contains the following columns:
he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales]) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?
A Data Analyst wants to create the following table in a view:
Which function should the analyst use to create the Position column?
A Data Analyst has the following dataset:
The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)
You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?
A Data Analyst is using containers on a dashboard.
How should the analyst make sure multiple objects within a container are always taking up the same width or height, even if the container is resized?
In a worksheet, you have a calculated column named YTD Sales that uses the following formula.
[Order Date] <= TODAY () AND DATETBUNC {“year”, [Order Dace]) = DATETPUNC)"year", TODAY(J)
You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales.
How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.
You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?
A Data Analyst has the following dashboard.
Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?
