Other examples
As well as numerical aggregations, we can also create date or selector aggregations, using the Recency aggregation type.
So, looking back at the example of holiday bookings, how could we select people who have had more than 3 bookings, such that their first and last destination is the same?
Old solution – before combining them within an Expression to achieve the result.
The Recency aggregation type cyprus mobile numbers is very similar to the existing Recency wizard. It allows you to order your transactions by an ordinal variable and then pick a specific data item from a specific record.
Recency Wizard
In this instance we are returning a Selector data type, so we need to wrap this in one of the Selector functions and test for equality. The full expression is shown below – each aggregation has been named within the expression to ensure that its purpose is clear.
on-the-fly_part_1_-_internal-5.jpg
Testing the expression shows some records for which the condition holds and others where it doesn’t. Our expression is behaving as we expected it to.