- Simple calculations: These calculations allow you to create new fields at either the same level of granularity as your dataset (row-level) or aggregate data at the granularity of the visual.
- Level Of Detail (LOD) expressions: LOD calculations are an extension of simple calculations but allow you to have more control over the granularity of the data you are working on. You have options to work to specify a FIXED level of granularity or INCLUDE data fields to the visualization granularity or EXCLUDE them.
- Table calculations: Table calculations only work at the level of granularity of the visuals. These allow you to build calculations at visual levels of top of your existing data or simple calculations.
The type of calculation you require will depend on the use case of your problem. If you already have all of the data you want to answer the questions, then you need table calculations. If you do not have all of the data you need, but the data needed will be at the same granularity as your dataset, you will need a basic calculation. Otherwise, it will be a LOD calculation.
Do not worry if you are a bit confused about the types of calculations. We will cover each type in detail in separate chapters. This chapter will cover simple calculations in detail while the next two will cover the other two calculation types. So, let's look at how to create simple calculations.