The term Fill Down is from Excel where we may need to fill all the empty cells below a non-null cell with the same cell value. Excel has a Fill Down button in the menu bar for a single cell fill down. We may also have to fill down between multiple non-null cells in the same column. Here is a post on how to do it.
This works in the horizontal direction as well.- In Excel, the fill down is at the cell level. A single cell is enough to initiate a fill down.
- In Tableau Desktop, the fill down is at the aggregate level. A companion dimension is needed in addition to a non-null attribute value to initiate a fill down.
For example, a data set is as follows about project management.
To create a project flow chart using Gantt bars, we need to fill down from the left table to the right as follows:Show Missing Dates
First, to generate the Date column, we just need to turn on 'Show Missing Values' in the drop down menu of the Date pill. This is also called data densification in Tableau. This populates the dates between the sparse dates in the original data set.Fill Down with String Values
Fill Down with Numeric Values
- IFNULL(MAX(Size), PREVIOUS_VALUE(0))
Add a comment