Tableau Updated Desktop-Specialist Exam Questions and Answers by denis

According to the [Tableau Desktop Specialist Exam Guide], a join is a way to combine table columns in relational databases by using shared values. A join can be inner, left, right, or full, depending on how the matching rows are included or excluded.

To change a measure so that it automatically aggregates as an average instead of a sum, you should right-click the field in the Data pane and select Default Properties. In the Default Properties menu, you can set the default aggregation for the measure, such as setting it to calculate an average by default when added to a view.

Explanation

Follow along to get the correct answer:

• Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :

2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:

2.1 As it is (continuous)

2.2 Converting to discrete first & then using it

and then :

3) We can now see that France, with 485 has the 2nd most number of patents for the year 2013

From the official Tableau documentation:

As we can see below, Bar charts can be used as a floating object.