In this blog, we will consider these types of questions that are now answerable with the new grouping aggregation functionality:
Which product was our 2nd most frequently purchased by each person?
How many products have I spent more than a given amount on?
How many products have I bought multiple times in multiple years?
New call-to-action
(*1) – Calculated measures can cyprus mobile number example refer to each other so some other scenarios can be achieved by linking together measures. Examples include functions and calculations across multiple measures.
In this blog we introduce new powerful functionality for transactional analysis based upon grouping transactions into categories and returning values based on them.
Person with coffee
Once we have these group results we can then apply a further function to get an end result. One such simple example would be to return the Maximum value – this is then the ‘most we have spent on a destination’. For the person above that value would be £4000.
Worked Examples
Let’s see this in action on our example Holidays system.