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

Enable the Summary Card from Show/Hide menu as shown:

Skewness is .42

The upper whiskers extends to 1.5 * IQR

The length of the upper whisker is upper hinge + 1.5 * IQR.

Create the calculated field:

Drop the carrier name to the view and % of delayed flights to text.

We only have 2013 data, so filter won't make a difference:

Create a hierarchy using City-Airport Name-Carrier Name.

Filter using Ontime Category field and select the Ontime.

Drop the hierarchy to the view and Number of flights to the Text.

Check each combination from the answers:

When you add a table calculation, you must use all dimensions in the level of detail either for partitioning (scoping) or for addressing (direction).

Refer: https://help.tableau.com/current/pro/desktop/enus/

calculations_tablecalculations.htm

Drop the Country field to the view.

Drop the Region to the filters shelf and select Europe & Central Asia.

Drop the GDP per capita to the label and change the aggregation to Avg.

After following the steps mentioned in the question your view will look like this:

Here, 5 points are above the exponential trend line.

Approach 1 -- Using Groups

Drop the Customer ID to the Rows.

Add sub-category to the filter and select phone.

Add Order date to the filter and select the year 2014.

Select all the customers and click on paper clip icon to create the group.

So here we got all the customers who have purchased any product in the Phones subcategory in 2014.

Edit the group and select Include other

Clear the filter shelf, and again add Order date to the filter and select 2015.

Drop Sales to the Text.

Add 'Percent of Total' Quick Table Calculation to the Sales field.

Your view will look like this:

Approach 2 -- Using LOD

Create a LOD expressions as:

It will return 1 for the customers who have purchased any product in the Phones sub-category in 2014. For others, it will return 0.

Drop this field to the Rows and add Order date to the filter and select the year 2015.

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