Salesforce Updated Analytics-DA-201 Exam Questions and Answers by kade

The LAST() function in Tableau returns the number of rows from the current row to the last row in the partition. When you compute using ' Order Date ' , it will change the partitioning of the calculation. If ' Consumer ' in ' 2018 ' is the last row in its partition when computed by ' Order Date ' , then LAST() will return 0 for that cell.

The LAST() function in Tableau is a table calculation that returns the number of rows from the current row to the last row in the partition. The value of LAST() is 0 for the last row, increases by 1 for each row above the last row, and can be negative for rows below the current row if there are such rows in the partition.

In the provided visualization, LAST() is set to compute using Table (across). Changing the compute mode to use " Order Date " will adjust the partitioning of the data upon which the LAST() function is calculated. Since " Order Date " is likely to be a unique value per row (assuming each order has a unique date), each row becomes its own partition.

For the Consumer segment of the year 2018, if " Order Date " is unique for each row, then the last row in each partition (in this case, each individual row) will have a LAST() value of 0 because there are no other rows in the partition - it ' s the last row of its own partition.

Therefore, when you change the compute mode of LAST() to use " Order Date " , each cell under the Consumer segment for the year 2018 will have the LAST() value of 0, because each order date creates a partition of one, making every row the last in its partition.

B is the verified answer; the selection shown in the candidate PDF is not reliable here. The difficulty is that FullName contains a variable number of space delimiters. A simple “split all” operation would produce First | Last for a two-part name but First | Middle | Last for a three-part name, so the second result column does not consistently represent the middle name. Tableau’s Custom Split functionality allows splitting from the first or last occurrences of a delimiter. The analyst can therefore reliably extract the first and last names regardless of whether a middle name exists, and derive the middle component when present. Tableau’s documentation notes that Custom Split provides control over first N, last N, or all occurrences and is useful when separator counts vary between records.

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: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_rank.htm