In this chapter we explored the inner workings of table calculations. We began by considering two questions, that is, What is the function? and How is the function applied?
As we explored these two questions, we surveyed each unique group of table calculation functions with the exception of the Script_
functions, which are covered in Chapter 13, R Integration. We also learned how to apply these functions to a view via partitioning and addressing.
In the next chapter, we will explore level-of-detail (LOD) calculations, where we will build a sound understanding of this functionality which, though introduced in Tableau 9.0, is still unfamiliar to many Tableau authors. Along the way, we will discover how LOD calculations can easily accomplish tasks that were previously only possible through complex table calculations. It is important to note, however, that even though LOD calculations can replace table calculations in some cases, they can by no means replace every instance of table calculations...