Tableau Desktop Specialist — Question 72

A Data Analyst is frequently asked to report on events that have a single row per day but may have missing days in the dataset. The analyst needs to fill the gaps in the data between two dates.

What should the analyst use to do this in Tableau Prep?

Answer options

• A. Union
• B. Pivot
• C. Aggregate
• D. Now Rows

Correct answer: D

Explanation

The correct option, Now Rows, allows the analyst to create missing rows for the days that are not present in the data, ensuring a complete daily record. The other options, such as Union, Pivot, and Aggregate, do not directly address the need to fill in missing date rows within a range.