This is just one of several frequency aggregations that we’ve included within the below to try and find out which continent each person has had the most bookings to in the last year. If they’ve not had any bookings then we give them a value of None.
We then create selections based on the above expression for the six possibilities and use those as the definitions of our segments. For each time point within the Segmentation time cyprus mobile number example report the filter selections are translated to In the report below, the highlighted figure of 2,806 are the customers who had more holidays to Asia than any other continent in the year prior to 01/01/2015 (i.e in 2014) (1).
On-the-fly Aggregations part 3
This kind of approach allows a lot of flexibility for defining complex segmentation selection rules that use a number of on-the-fly aggregations. Other examples of use could be in establishing that a customer had two transactions in the last 60 days and that there was a maximum of 30 days between them.
Conclusions
We can see that there are more in-depth uses of the on-the-fly aggregation functionality introduced in the Q4 2017 release. These extensions add another layer of power and flexibility to their usage within both the expression and segmentation tools.