In the previous chapter, we covered table calculations, which are extremely useful when we want to aggregate information using exactly the data that is in the view, but sometimes we want to use more (or less) than the information that can be seen on the screen. For instance, if you want to show the average spend by customer, you don't want to show all customers and their value to compute an average. This is where Level of Detail (LOD) calculations, which we will introduce in this chapter, can be used, because they help us change the level of aggregation.
The following topics will be covered in this chapter:
- Tableau's order of operations
- FIXED LOD calculations
- INCLUDE LOD calculations
- EXCLUDE LOD calculations
- Data source constraints for LOD
