Table of information
In this final example we extend the scenario further by using 2 categorical variables. We start with the existing grouping into each Destination. We then need to work out the number of times we have visited each destination in each year (essentially a 2D cube for each person with a count measure) by using a function of Frequency(Booking Year). We apply a range to the individual destination/year combination to ensure that there are exactly 2 visits, and then to the number of years which are populated to ensure a minimum of 2, as per the interface below.
Table with details in
Again, the result will be a flag array croatia phone number example since each person could have 0, 1 or many destinations which satisfy the above criteria. In the example below, I have highlighted two people with 1 destination matching the criteria, although the destination is different in each case. Note that for both people they have had further bookings to each of the destinations but they did not match the range for the first part of the condition so had been removed prior to the number of years range being matched.
Table with details in
It is possible to select people who have for example booked exactly twice to a destination in 2 separate years and not at all in any other years by combining this with a further grouping aggregation.
In this 2 dimensional case there are other functions which can also be used instead of this InRange example as shown in the football section that follows.