How to perform data densification in Tableau
Data densification is a largely undocumented aspect of Tableau that can be useful in many circumstances but can also be confusing when encountered unexpectedly. In this article we will provide information about data densification with the intent of dispelling confusion and providing the Tableau author with sufficient knowledge to use this feature to their advantage.
We will begin with understanding Data densification, Sparse Data, Domain Completion, and Domain Padding.
- Data densification: A behavior wherein Tableau displays marks in the view for which there is no corresponding underlying data.
- Sparse data: An intersection of one or more dimensions and one measure for which there is no value.
There are two types of data densification: domain completion and domain padding.
Domain completion is the more complex of the two and can be deployed cleverly to solve sparse data issues, but may also appear unexpectedly and prove a challenge to address.
Domain completion: The addition of marks on a sparsely-populated view that cause all possible dimension/measure combinations to display results.
Grasping domain completion requires a good understanding of dimensions and…