We are looking to create a dashboard that will count the unique order id's for each person who bought tickets to a specific show (specifically to see if any person has multiple order for the same show - resellers) and then limit what we see to only those with 2+ orders. Who knows a formula that will allow us to do that? We were trying to use COUNT with order ID but kept getting an error message.
Thanks in advance!
A restate would be "show me everyone who had two orders to X show". Is that right? If so, you could do (something) like this:
ROW- constituent ID / Display Name /etc.
Value = # of Order ID
Filter = show of choice
Then, filter by '# of Order ID" GREATER THAN 1
I think that should do it. You'd be only looking at one show (whichever show you want), and you'd be looking at a list of people who have 2 or more orders.