Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 7

Drop the State to the View. And drop the Country to the Filter Shelf and Select the United States.

Drop the City to the view, and add the State to the Filter shelf and select North Carolina.

Also, drop the Order Date to the Filters and select year 2012, 2013, 2014

Now, drop the Profit field to the tooltip. As of now, your view should look like this:

Now, we have to find the total profit earned by all the cities in Wake County.

Drop the City field to the view and drop the state to the Filters shelf and Select North Carolina only.

To show the County go to the Map->Map Layers.

Check County Names and County Borders.

the total profit earned by all the cities in Wake County is $403.

Create a calculated field as:

Drop this field to Rows and Total Death to the Columns. And Select the Quick Table Calculation-> Percent of Total.

While creating the parameter action, it is not mandatory to specify the aggregation.

All others are true.

Refer: https://help.tableau.com/current/pro/desktop/en-us/actions_parameters.htm

Use join Calculations while joining two tables.

While creating Bar in bar chart, we turn off the stacked marks so that both the bars will start from 0.

When you use a left join to combine tables, the result is a table that contains all values from the left table and corresponding matches from the right table.

Refer Join Types: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm

Drop Sector to columns and Funded Amount to Rows.

From Analytics, drop the Median with Quartiles to your view or drop the reference line, select the Median.

Your view will look like this:

Here, the Clothing funded amount is exactly similar to the Median.

Filter the Activity = Catering

Drop the activity to rows, and no of days to columns, change the aggregation to AVG.

Also, drop the Funded Amount to the Tooltip.