MaxCategory
Which destination have my customers spent most on?
Which communication channel is preferred by this customer?
All of these questions could have been answered previously using FastStats, but this extension to the on-the-fly aggregation functionality makes it much quicker to create and maintain objects that seek to answer them.
Prior to Q4 2017, a virtual variable cyprus mobile number example would have had to be created for each product grouping. This may have been acceptable when you have three products, but as the number of products increases it becomes a pain – quickly followed by too much hassle. Before the MaxCategory aggregations this could have been achieved by using an on-the-fly aggregation for each of the product groupings and a much more complicated expression. Now this can be achieved with a single on-the-fly aggregation.
Let’s look at an example of how to specify an on-the-fly aggregation using our fictitious holiday company FastStats system to answer the first of the questions posed above.
On-the-fly Aggregations part 3
Here we start by taking the transactions for each person and grouping them by the Destination variable into a number of sets. We then work out the Sum(Cost) for each of those sets and find the one with the highest value.