Max category
Scenario¶
Identify the most expensive product someone has purchased
.png)
- Click on the
Add Aggregation button and then on the tab entitled Frequency(Communications) that opens up - In the Type drop down select Max Category
- Set the Grouping Table to People and Transactional Table to Bookings
- Drag the Destination variable onto the Group Transactions by drop box
- Drag the Cost variable onto the Drop your numeric variable here box and leave the Order by as the default Sum
In this example we have grouped by destination and asked for the maximum cost in order to find an individual’s most expensive holiday destination.
A Data Grid can be used to validate the results:
.png)