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?
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.
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
This section is not available anymore. Please use the main Exam Page.TDA-C01 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
CollectiveConsciousness
Highly Voted 1 year, 3 months agoasiat2301
5 months, 1 week agoMonBouj
5 months agoShazzyHawk
Most Recent 2 days, 21 hours agoMonBouj
5 months agoGili_1370
10 months, 1 week agoJUT_TC
1 year, 1 month ago