Using nested calculated fields

Hi All,

Elaborating further on the four year old blog post linked below, i.e. the case with “Calculated field name : NumberOrdersPerCustomer” one could pose the further requirement:

“Limit the bar chart such that only those columns representing a number of orders per customer, posessed by a certain number of customers should be displayed”.

My Solution:

Add a nested calculated field:



Now, add a filter on this nested calculated field.

Create advanced insights using Level Aware Aggregations in Amazon QuickSight | AWS Big Data Blog


1 Like

Thanks for sharing @kaare! This will be very helpful