Page 1 of 1

We could then use this as an attribute

Posted: Mon Dec 23, 2024 4:44 am
by phonedata
Firstly, we would need to create a virtual variable to record the first transaction date for a customer and store that as a date variable (see column Date of First Booking below).

Secondly, we would need to create an expression to flag all records where the transaction date of that record was within one year of the variable we created in the first step (see In First Year of Booking column below). to apply the RFV selection to, or as a transactional selection within a further frequency virtual variable to cyprus mobile number example create the required value as a variable (see Number of Bookings in First Year column).

On-the-fly Aggregations part 3

We can use the on-the-fly aggregation functionality to work out all the steps below without having to create any virtual variables at all. The approach is similar to above.

The screenshot below shows the required steps. We start in the top left by creating an expression to work out the difference between the first booking date and the current booking date for all bookings.