Ace Your TDA-C01 Tableau Certified Data Analyst Exam

To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu. References:

In a dual-axis chart in Tableau, if you want to have two different visual mark types (like a shape and a line) and configure them differently (such as making one larger than the other), you would need to duplicate the measure. You then drag this duplicate to the second Marks card (which represents the second axis). There, you can adjust the size of the marks (shapes, in this case) independently of the line marks on the first Marks card.

A screenshot of a computer Description automatically generated

To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every [Category], which means that the ranking will reset for each category. References:

To configure the dashboard action, you should select Filter as the action type, Select as the run action on option, and All Fields as the target filters option. This will ensure that when a user selects a city on the map, the bar chart will show only the data for the selected city based on all fields in common between the two worksheets. The action will run only when the user selects a different city. References: