Hello!I'm creating a table which has a variety of information in it that I need for our post-concert wrap ups.The only column I'm missing is "How many tickets first time ticket buyers purchased"I currently use the formula below for the number of first time ticket buyers, but I would also like to know how many tickets those ticket buyers purchased.
Count([Constituent ID],IF(MIN(DDIFF([Days in Date],[Years in First Performance Date]))=0, MAX([Constituent ID]),NULL))
If I change Constituent ID to ticket count, the formula no longer works.I can get the number using a different widget, but its a pain as it requires a manual filter and can only display one concert at once. And I'd like it to all be in one widget!Wondering if anyone has any ideas?Cheers, Nicola
Hi Nicola,
I am wondering if you managed to get this working?
I am trying to do something similar. Instead of "how many tickets first time ticket buyers purchased" I want to do some Analysis on the price types in those orders.
For a couple of price types, I want to know out of all the orders where customers have bought them, how many were first timers.
Any help would be greatly appreciated!
Thanks, Donald
Hi Donald,
With a Production Season or Performance as a dashboard or widget filter, and with Price Types on rows of a Pivot Table widget, and a unique count of Constituent ID as the total number of constituents purchasing those price types, add a value such as Nicola's...
SUM ( [Constituent ID] , IF ( MIN ( DDIFF ( [Days in Performance Date] , [Days in First Performance Date] ) ) = 0 , 1 , 0 ))
This will give you the number of constituents purchasing those price types who are also first-time buyers within each of those price types.
Thanks! This seems a good fit for adding a column to our daily pivot that I hadn't even thought about trying to include.