Morning all!
I'm looking at identifying how many customers have purchased multiple products in one transaction, we weren't able to do this on our previous system so internally people are keen to know if habits have changed. I can see people who have purchased multiple events but not sure how to narrow this down to people who have booked multiple events/products in the same transaction.
Is this possible?! All thoughts welcome!
Diolch / many thanks,
Kirsty
Hey Kirsty,
Have you tried bucketing using multi pass aggregation. In the case below sub in [# unique Production Season] instead of ticket count. You'd have as many value "buckets" as you'd have prod seasons you could put into an order.
community.tessituranetwork.com/.../82912
I have a widget that shows how many shows constituents have purchased multiple performances. I did a little test to see if you could change this formula to pull order id instead of constituent id (can't remember who to credit this formula to, but I found it here), anyway I think it works.
In the screen shot here the first 6 numbers are looking at constituents and the bottom ones 1(1) and 2(1) are looking at orders.
Create a value for each number 1,2,3 etc until you aren't getting results on the large numbers.
Here is the formula for 1
sum([Order ID], if([# of unique Performance ID]=1,1,0))
This one is for 2
sum([Order ID], if([# of unique Performance ID]=2,1,0))
change that number after the equal sign for 3 and so on.