FastStats™ aggregation functionality
The [Cost] is the regular FastStats® variable for this booking record. The other two (shown enclosed by the {} symbols) are aggregations. The definition for one of these is shown below (the other is the same except with 2 instead of 1).
FastStats™ variable
We can then make a selection of people with a value of 1, and look at the relevant transactional detail to check that they are exhibiting the desired behaviour (as shown in the highlighted cyprus mobile numbers rows for two example people). Note that these behaviours are at different points within the transactional history for the two highlighted people.
on-the-fly-part-2-internal-3.jpg
Example 2
Aim: select people who have been on holiday to the same destination for their last three consecutive holidays.
This is an example of a question that we could have previously answered because we have been specific about which particular set of transactions to consider. We would have had ‘Last Destination, ‘2nd Last Destination’, ‘3rd Last Destination’ and then use an expression to check their equivalence.
Our approach now is similar, but we also need to use the Rank function to ensure that the destination we are considering is the Last one by Rank and then check the two previous ones are the same.