Learning Tableau 2019 - Third Edition

Four main types of calculations

The groupings of functions we mentioned previously are important for understanding what kind of functionality is possible. However, the most fundamental way to understand calculations in Tableau is to think of four major types of calculations:

• Row-level calculations: These calculations are performed for every row of underlying data.
• Aggregate-level calculations: These calculations are performed at an aggregate level, which is usually defined by the dimensions used in the view.
• Level of detail calculations: These special calculations are aggregations that are performed at a specified level of detail, with the results available at the row level. We'll cover these in detail later in this chapter.
• Table calculations ...