Partition and direction of addressing

As discussed in Chapter 1, Reviewing the Basics, calculated fields can be categorized as either row-level, aggregate-level, or table-level. For row- and aggregate-level calculations, the underlying data source engine does most (if not all) of the computational work and Tableau merely visualizes the results. For table calculations, Tableau also relies on the underlying data source engine and the available RAM on your machine to execute computational tasks; however, after that work is completed and a dataset is returned, Tableau performs additional processing before rendering the results.

Let us look at the definition of table calculations, as follows:

A table calculation is a function performed on a cached dataset that has been generated as a result of a query from Tableau to the data source.

Let us consider a couple of points regarding the dataset in the cache mentioned in the preceding definition.

This cache is not...