Data densification can take place in the source if you choose to fill in missing data with certain joins, unions, or custom queries. But here, we are focused on data densification that takes place in Tableau after aggregate data is returned from the source. Specifically, under certain circumstances that we'll consider, Tableau fills in missing values in the aggregate data in the cache, as seen in the following figure:
You'll recognize that the preceding figure is very similar to the figure we examined when we started the discussion of table calculations. In fact, data densification happens at relatively ...
