In this chapter, we are going to learn about the power of calculation engines. After reading this, you will understand how to create a calculation with conditions, as well as how to use the aggregation scope, inter-record functions, and advanced aggregation with the AGGR function. Finally, you will learn how to use Set Analysis to create a calculation with very specific data.
For each topic, we will create several visualizations to help us interact with the expressions and also use some additional functions to check whether there is selected data on fields.
The following topics will be covered in this chapter:
- Creating calculations with conditions
- Using TOTAL for aggregation scope
- Using some useful inter-record functions
- Using AGGR for advanced aggregation
- Leveraging Set Analysis for in-calculation selection