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

First, create a set using the Product Name. Select the Top condition as:

Drop this Set to the filters shelf and select IN only.

Drop this Set to the filters shelf and select IN only.

Drop the Category, Top 10 profitable products and Product Name to the view:

Drop the Sales to the Rows and disaggregate the values. (Go to Analysis -> uncheck Aggregate measures)

From Show Me, Select Box and Whisker plots. And drop the Ship mode to the columns.

Hover on each of the boxes:

Median for the First Class and Same Day ship modes are 84.

Open Regional Dashboard twbx file, and select the region as Northeast and state as New York:

Hover the trend line of Obesity correlation with exercise chart, 0.57 percentage of average obesity increases when 1% average increase in the physical inactivity in the Northeast Region.

However, we have to find out for the New York State. Currently, when you have selected the New York state, the trend lines have not been recalculated.

To recalculate it, right-click on the trend line and click on Edit All Trend Lines:

In Trend Line Options, select the Show recalculated line check box:

Hover the trend line of Obesity correlation with exercise chart, 0.40 percentage of average obesity increases when 1% average increase in the physical inactivity in the New York State in the Northeast Region.

Here we have to use the Obesity View only, so let's go to that sheet:

Click on go to sheet as per above.

Edit the State filter and select only North Carolina:

Duplicate this sheet as Crosstab

3 counties in North Carolina are having an obesity rate that is 8% below the regional obesity rate.

Note: For dashboard questions, I prefer to follow above approach wherever it is applicable. I find it easy to get the answers.

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

Go to the section- Phone layouts and the Default dashboard

Drop the country field to the view and also to the filter and select Australia.

Drop the State to the detail marks card.

Create the Unique Customer field to the Label.

Your view will look like this:

Northern Territory has the minimum unique customers -- 19.