In this module, we will use the dataset that you created in Module 1 (Build your first dashboard).
In QuickSight, Calculations can be defined in analysis layer or dataset layer.
When defined in analysis layer, the calculations are always evaluated on analysis/dashboard load.
sIf pushed on to dataset layer, row level calculations will be precomputed and results stored. ie - If your dataset is in SPICE mode. Pushing aggregate calculations to dataset layer helps in centrally storing the calculation and making it available for ready use to all dataset users. However, it doesn’t yield any additional performance benefits as aggregate calculations as always evaluated in context of the visual it is used in.
Understanding the order of evaluation of filters, calculations and aggregations iis important. Take a moment to go through the below diagram to understand the same.
In the exercises that follow, we will explore this sequence further.