Using nested calculated fields

Question & Answer
,
1

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:

NumberOfCustomersWithNOrders=

distinctCountOver({customer_id},[NumberOfOrdersPerCustomer],PRE_FILTER)

Now, add a filter on this nested calculated field.

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

Cheers
Kaare

1 Like
2

Thanks for sharing @kaare! This will be very helpful

3