Tableau Updated TDA-C01 Exam Questions and Answers by owais

we need to create a quick table calculation that shows the percent of total sales for each category and sub-category. To do this, we can follow these steps:

Drag Category to Columns and Sub-Category to Rows.

Drag Sales to Text on the Marks card.

Right-click Sales on the Marks card and select Quick Table Calculation > Percent of Total.

Right-click Sales on the Marks card again and select Compute Using > Category.

This will create a quick table calculation that shows the percent of total sales for each sub-category within each category. The visualization will look like this:

To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])). This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.

Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):

Student ID 4183: 39 (Rank 1)

Student ID 4220: 71 (Rank 6)

Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank)

Student ID 4124: 75.5

Student ID 4050: 64

Student ID 4205: 67

Student ID 4056: 66

Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.

Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.

https://help.tableau.com/current/prep/en-us/prep_calculations.htm