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?
Tableau Prep provides a New Rows step specifically for filling gaps in sequential numeric or date data. When a dataset should contain one record per day but some dates are absent, New Rows can generate the missing date records between existing dates or within a defined range. The analyst can set the increment to one day and choose how other fields in the generated records are populated, such as Null, zero, or values copied from the previous row. Union combines rows from separate tables, Pivot reshapes columns and rows, and Aggregate changes the level of detail by grouping records. None of those operations is designed to manufacture missing dates in a sequence. Therefore, New Rows is the correct Tableau Prep operation for this requirement.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit