Smallest order span field options in pattern match controls
Posted: Mon Dec 23, 2024 4:16 am
Examples
Find all the people who have made a booking to USA then to Australia and then to USA again within a 10 day period. To do this, we can find the smallest order span for all of the matched (USA-AUS-USA) patterns.
We can then add this aggregation expression to a selection and select upon this numeric value to find the 55 people in our Holidays system that have had the transactional behaviour croatia phone number example required. Two of those people and their transactions are shown in the grid below.
Pattern match grid
Example 2 – Find people who have been to USA-AUS-USA in the last 3 months.
For this example we use the same pattern values as above and then select the start date of the last time that the USA-AUS-USA was matched, by using the settings below.
Pattern value selections
We can then expand the expression to:
Expression
This expression can then be added to a selection and we can select upon the resulting value from the above to be < 90 days. This will then give us all the people who have undertaken the USA-AUS-USA pattern within roughly the last 3 months.
Find all the people who have made a booking to USA then to Australia and then to USA again within a 10 day period. To do this, we can find the smallest order span for all of the matched (USA-AUS-USA) patterns.
We can then add this aggregation expression to a selection and select upon this numeric value to find the 55 people in our Holidays system that have had the transactional behaviour croatia phone number example required. Two of those people and their transactions are shown in the grid below.
Pattern match grid
Example 2 – Find people who have been to USA-AUS-USA in the last 3 months.
For this example we use the same pattern values as above and then select the start date of the last time that the USA-AUS-USA was matched, by using the settings below.
Pattern value selections
We can then expand the expression to:
Expression
This expression can then be added to a selection and we can select upon the resulting value from the above to be < 90 days. This will then give us all the people who have undertaken the USA-AUS-USA pattern within roughly the last 3 months.