TDA-C01 Exam - Question 33

Question

You have the following visualization.

The Last() calculation is set to compute using Table (across).

Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Order Date?

Examice · Accepted Answer

When you set LAST() to compute using Order Date, it will calculate the position of each row relative to the last row in the partition. In this case, the year 2021 is the last order date, which would correspond to 0 when computing LAST(). Moving backwards, 2020 would be 1, 2019 would be 2, and 2018 would be 3. Therefore, the value that appears in the crosstab for the Consumer segment of the year 2018 would be 3.

CollectiveConsciousness · Answer

The answer is incorrect. last() uses 0 inclusively, therefore the highest value we can obtain is 3. When computed by order date, it would consider the latest date 0 while the 2018 date as a 3.

JUT_TC · Answer

3 is the answer

Gili_1370 · Answer

B:3 ist the answer

MonBouj · Answer

B. 3
(tested)

ShazzyHawk · Answer

LAST() gives the number of rows from the current cell to the last cell in the partition.
When Compute Using is Order Date (i.e., down the table), it processes data vertically for each Segment column.

So for the Consumer segment, here's what LAST() returns for each year (since the partition is vertical for that segment): 3

TDA-C01 Exam - Question 33

Discussion