Tableau Desktop Specialist — Question 109

Which syntax should a Data Analyst use to find the first purchase date per customer when customer is not in the view?

Answer options

• A. { [Customer ID] : MIN( [Purchase Date]) }
• B. { FIXED [Customer ID] : MIN( [Purchase Date]) }
• C. [Customer ID] : ( (Purchase Date])
• D. MIN( [Purchase Date])

Correct answer: B

Explanation

The correct answer is B, as using FIXED allows the calculation to consider each Customer ID regardless of whether it appears in the current view. Option A lacks the FIXED keyword, thereby not guaranteeing the correct aggregation in the absence of Customer ID in the view. Options C and D do not correctly implement the syntax needed to achieve the desired result.